Running this now, however I'm getting an issue where the first one works with XX00001, but the next one is XX2 and then it fails, saying it can't be converted into a number. Any help would be greatly appreciated
@@powerappsacademy9460 I'm having the same issue and when I'm editing the column in sharepoint, it isn't giving me the option to format the Title column as text. I'm going to try to simply create a new column instead of trying to use that tricky "Title" column, which I think my organization has attached things to...
Just started using power apps for my job and was tasking creating a tracker. The video was fairly easy to follow however one thing that I noticed which might be something different all together that i need but it looks like its just updating the row with the auto increments I was thinking from the title that it would create an additional entry with the auto increments if that is something else do you have a video that tackles that for every new entry.
Would it be possible to loop through this multiple times creating multiple ID's? I'm looking to create an app where a user would enter a number of labels they need, then it would create that many new ID's and then print them out.
Hi Barry, can you help me? Mark this error when generating the consecutive if I add the word echo. (The value 'ECO0003000' cannot be convert to a number , Set(varRefNum1,First(Filter(trackineco,Eco="ECO")).Título); UpdateIf(trackineco,Eco="ECO",{Título:Concatenate("ECO",Text(Right(varRefNum1,10)+1))});
Hi Barry, thanks a lot for this video and this is great. I am developing a similar app for my team and I want to have the ability to create a new line in a share point list every time a new response is submitted with a new incremental unique reference. Right now I am using flow to do this using the share point ID, but it’s a bit too slow for my application. Do you think you’ll be able to guide me on this or create a video. Thanks loads in advance.
Great video! thank you! It is exactly what I was looking for. The only thing that did not work for me is because my number begin with 0 (zero) and not 1... So, when I update, the number generated pass from "R-00000500" to R-501 and creates an error for the next one. (concatenate doesn't work anymore)... Maybe if you have a solution for this problem, I will take it! thanks a lot again!
HI Barry, This is a great video thank you so much. I have utilised it on a Quote Form I have put together. How can I get the reference number to populate a field in my SharePoint list now. I want the number to stay with a particular quote when they employee hits Submit.....TIA
Patch it in if saving a new line e.g. patch(sharepointlist, defaults(sharepointlist), { column1 : yourtextbox.text } ..... If you are updating a row that already exists, use the Updateif() function
Good morning Barry and thank you....this is EXACTLY what I am looking for. My manager now wants 2023-001 to change to 2024-001 when the year changes. How do i perform that code?
My suggested fix is to write the reference number to sharepoint once it is generated, and perform a check before writing it to see if ut already exists. If it already exists in Sharepoint then generate a new one else continue. This may help allevaite the issue.
I usually don't worry about gaps in the auto incrementing number. But you could create a button to reset it to the previous number by modifying the code provided to subtract one instead of Adding.
Thanks Barry!!! for making me look like a pro at work😅
Thanks, Barry - this was just what I needed for a couple of apps that I am trying to put together! Learning as I go...!
Glad it was helpful!
Awesome tip! Thank you for sharing 👍🏻
Hi Barry! Thanks a lot for video.
You are very welcome
Running this now, however I'm getting an issue where the first one works with XX00001, but the next one is XX2 and then it fails, saying it can't be converted into a number.
Any help would be greatly appreciated
Please confirm that the Sharepoint column is set to text and not a number type
@@powerappsacademy9460 I'm having the same issue and when I'm editing the column in sharepoint, it isn't giving me the option to format the Title column as text. I'm going to try to simply create a new column instead of trying to use that tricky "Title" column, which I think my organization has attached things to...
Just started using power apps for my job and was tasking creating a tracker. The video was fairly easy to follow however one thing that I noticed which might be something different all together that i need but it looks like its just updating the row with the auto increments I was thinking from the title that it would create an additional entry with the auto increments if that is something else do you have a video that tackles that for every new entry.
Would it be possible to loop through this multiple times creating multiple ID's? I'm looking to create an app where a user would enter a number of labels they need, then it would create that many new ID's and then print them out.
Hi Barry, can you help me? Mark this error when generating the consecutive if I add the word echo. (The value 'ECO0003000' cannot be convert to a number , Set(varRefNum1,First(Filter(trackineco,Eco="ECO")).Título);
UpdateIf(trackineco,Eco="ECO",{Título:Concatenate("ECO",Text(Right(varRefNum1,10)+1))});
ensure the column in Sharepoint is set to TEXT column type and NOT number column type
When both users parellely create button at same time then the reference number will be same for both
@sridharreddy1607 Thanks for sharing. Did you find a way around this?
Hi Barry, thanks a lot for this video and this is great.
I am developing a similar app for my team and I want to have the ability to create a new line in a share point list every time a new response is submitted with a new incremental unique reference. Right now I am using flow to do this using the share point ID, but it’s a bit too slow for my application.
Do you think you’ll be able to guide me on this or create a video.
Thanks loads in advance.
@ashainfernando5748 this should be quite easy to do, did you manage to find out how? Sorry I did not respond earlier.
Great video! thank you! It is exactly what I was looking for. The only thing that did not work for me is because my number begin with 0 (zero) and not 1... So, when I update, the number generated pass from "R-00000500" to R-501 and creates an error for the next one. (concatenate doesn't work anymore)... Maybe if you have a solution for this problem, I will take it! thanks a lot again!
HI Barry,
This is a great video thank you so much. I have utilised it on a Quote Form I have put together. How can I get the reference number to populate a field in my SharePoint list now. I want the number to stay with a particular quote when they employee hits Submit.....TIA
Patch it in if saving a new line e.g. patch(sharepointlist, defaults(sharepointlist), { column1 : yourtextbox.text } ..... If you are updating a row that already exists, use the Updateif() function
@@powerappsacademy9460 Hey Barry - these are great videos thankyou - would you be able to do a video demoing this patch please?
@@gaelrobinson3640sounds like a good topic for next video.
Good morning Barry and thank you....this is EXACTLY what I am looking for. My manager now wants 2023-001 to change to 2024-001 when the year changes. How do i perform that code?
Thanks for reaching out. My video I am posting on Monday is covering your request. Please subscribe to get notifications when I post the tutorial. 🙏
Here is the link to the tutorial I recorded based on your request. Thanks for recommending the update: ua-cam.com/video/bNWTecMhUwE/v-deo.html
Hi Barry! Thanks a lot for this. however, I experienced a duplicate ID when multiple users clicked the submit at the same time. :)
@matthewlim4642 Thanks for letting us know. Did you find a resolution l?
My suggested fix is to write the reference number to sharepoint once it is generated, and perform a check before writing it to see if ut already exists. If it already exists in Sharepoint then generate a new one else continue. This may help allevaite the issue.
You should have explained how to reduce the number in case the record is deleted.
I usually don't worry about gaps in the auto incrementing number. But you could create a button to reset it to the previous number by modifying the code provided to subtract one instead of Adding.
@@snipesnab yeap, that's an ideia, I don't even know how I didn't think of that, sometimes I am dumb lol. Thanks!
Thanks
Welcome