Power Apps - Create an auto-incrementing reference number

Подписаться 1,5 тыс.

Просмотров 12 тыс.

50% 1

** Please LIKE & SUBSCRIBE to help our channel grow **
Go to www.powerappify.com/ for useful ready-made Power App templates
In this video, you will learn how to create an automatically incrementing reference number to use in your Power Apps. The number is stored and updated in SharePoint so that you can be sure the number will never be used twice.
If you want to watch the previous video where we built the initial form in the example, click on this link to the following tutorial videos:
• Power Apps Live Demo -...
• Power Apps - Understan...

Развлечения

Опубликовано:

21 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 26

@solomonokechukwu7540 5 месяцев назад

Thanks Barry!!! for making me look like a pro at work😅

@dianemattheson4389 9 месяцев назад

Thanks, Barry - this was just what I needed for a couple of apps that I am trying to put together! Learning as I go...!

@powerappsacademy9460 8 месяцев назад

Glad it was helpful!

@mdhidayat5706 7 месяцев назад

Awesome tip! Thank you for sharing 👍🏻

@JohanAmaro 8 месяцев назад

Hi Barry! Thanks a lot for video.

@powerappsacademy9460 8 месяцев назад

You are very welcome

@ashainfernando5748 8 месяцев назад

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.

@sridharreddy1607 2 месяца назад

When both users parellely create button at same time then the reference number will be same for both

@MarieOliviah 4 месяца назад

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!

@neilejc 6 месяцев назад

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 6 месяцев назад

Please confirm that the Sharepoint column is set to text and not a number type

@LisamarieSC1 4 месяца назад

@@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...

@juancarlosmedranomolina1867 5 месяцев назад

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))});

@powerappsacademy9460 5 месяцев назад

ensure the column in Sharepoint is set to TEXT column type and NOT number column type

@basehumax 9 месяцев назад

Thanks

@powerappsacademy9460 8 месяцев назад

Welcome

@user-bc1re6md3c 8 месяцев назад

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

@powerappsacademy9460 7 месяцев назад

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

@gaelrobinson3640 3 месяца назад

@@powerappsacademy9460 Hey Barry - these are great videos thankyou - would you be able to do a video demoing this patch please?

@snipesnab 3 месяца назад

@@gaelrobinson3640sounds like a good topic for next video.

@mce8183 8 месяцев назад

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?

@powerappsacademy9460 8 месяцев назад

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. 🙏

@powerappsacademy9460 8 месяцев назад

Here is the link to the tutorial I recorded based on your request. Thanks for recommending the update: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-bNWTecMhUwE.html

@HiroshimaMS 6 месяцев назад

You should have explained how to reduce the number in case the record is deleted.

@snipesnab 6 месяцев назад

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.

@HiroshimaMS 6 месяцев назад

@@snipesnab yeap, that's an ideia, I don't even know how I didn't think of that, sometimes I am dumb lol. Thanks!