Hello, I have a question about unique id. So I have 2 lists, parent and child. I use automate to generate the parent id everytime a parent item is created, for example, 2022001, 2022002.... 1 parent can have multiple child, for the child id, I need it to be 2022001-01, 2022001-02, then for another item, 2022002-01. Is there anyway to achieve this? thanks!
HI, sure it's more than possible, personally if I have One to Many relationships like that I prefer to just use two tables and use the Parent ID as the relationship across the columns. But it sounds like you may be talking about concatenating the Parent ID with a new Child ID, maybe worth considering the relationship route which will take away some complexity
Great video. Here a newbie of powerapps. I'm looking to achieve something similar to what you demonstrated in your video. In my case I have created an app that employees can use to report their absence from work. The app contains a form with basic information such as the employee's number and name, work area, etc. What I am trying to achieve is that when the employee submits the absence form, there will be a new window with a confirmation number. This number must be the same number for 24hrs. After 24 hours the number should change for the new day. Is this something that can be achieved in powerapps? Do you think my question could be material for another magnificent video of yours? Thanks in advance.
Kindly assist me to come up with a solution that would help me generate a unique ID. i have a list where one unique ID can have several entries how can i achieve this(i.e an ID has several Purchase Order Numbers (PO Numbers) related to it
This is relational data 101! expand your tables if there are 1:N (one to many) rows, create related tables, its not easy in SharePoint but possible, much easier in Dataverse
Great video!!! Here a newbie of powerapps. I'm looking to achieve something similar to what you demonstrated in your video. In my case I have created an app that employees can use to report their absence from work. The app contains a form with basic information such as the employee's number and name, work area, etc. What I am trying to achieve is that when the employee submits the absence form, there will be a new window with a confirmation number. This number must be the same number for 24hrs. After 24 hours the number should change for the new day. Is this something that can be achieved in powerapps? Do you think my question could be material for another magnificent video of yours?
Hi, I had a question maybe you can solve it. If I have an excel file as the data source and I create an app. When the user adds his id he must be able to see only his data(specific fields, not all the fields say if I have 5 fields name, surname, id, course, class, and school. when the user inputs his id he would see only his name and surname ) a. How can I do this using powerapps? It would be great if you teach us this.
Thanks Kakan, this is certainly possible I tend to stear away from excel as a data source but I would be happy to do a video and show you how this could be possible!
Hey! Great video! I have a question. I want to make a unique id/ workorder number, which would auto generate work order number incrementally, so that every time I submit the form, it emails the recipient the new order number and report. You think there’s a way to do that?
Thanks, glad you enjoyed it! There sure is, incrementing the number means we need to know the last submited work order so we need to be storing the submissions in a data source (SharePoint List, SQL or something else) SharePoint and SQL will have a primary Key (In SharePoint this is the ID field) which is automatically incremented every time a new item/row is added, we can use this or create our own work order number field. If you use the built in ID field you just need to create a new item and the ID field will automatically have incremented, the Patch function can create a default Item and also returns the newly created item. Set(NewItem, Patch('SharePointList',Defaults('SharePointList'))) -> Create a new item with default fields and set it to a variable NewItem.ID -> Access the ID which has been automatically incremented by SharePoint to use in our app OR Using the below formula we can get the highest number in the field (sort all items by the field, descending and just use the first) and then all our app would need to do is add 1 to the number. First(SortByColumns('SharePointList', "WorkOrderNumber", Descending)).WorkOrderNumber-> gives you the highest number in the workOrderColumn Using Concatenate you could then also add in your own random number or text, the options are endless :) I will add it to my list of videos for future!
Fluid SharePoint thanks for the reply. I understand that if there is a previous record stored somewhere, I can have the powerapps increment it. But let’s say, in my case, I created an app for inventory, which sends an email report (created using htmltext in powerapps) to the concerned department, I don’t have any previous data, nor do I want to extract it from anywhere, I want to natively work in powerapps. I have figured out everything, if I could get the work order number to auto increment, that would be perfect. But none the less, looking forward to your upcoming videos. Great work and good job!
@@knubbe Hi, you can get it to increment within the app but each time the app is loaded it needs to know the last number which was sent and the app cant be updated with this information in itself, the best and only way I know to do this is to at least have a log in a database(SharePoint List) and look it up when the app loads. Having a log is always a good idea so that you can find out where if ever things go wrong or if users are telling you something didnt happen.
For sure, all we are doing is concatenating strings to make a string, you can use the User() function to get full name surname, you will need to get the first character on each string to bring it all together using Left(string, 1) on the full name and surname, if you don't get it let me know I can throw you a video!
Hi, correct on its own it wont necessarily be 'Unique' although the more numbers you use the less chance of a duplication, I tend to use this technique in conjucntion with the unique ID provided by the data source (SP List ID or SQL ID) to make sure its 100% unique or in some situations generate a guid :)
Hello, I have a question about unique id. So I have 2 lists, parent and child. I use automate to generate the parent id everytime a parent item is created, for example, 2022001, 2022002....
1 parent can have multiple child, for the child id, I need it to be 2022001-01, 2022001-02, then for another item, 2022002-01. Is there anyway to achieve this?
thanks!
HI, sure it's more than possible, personally if I have One to Many relationships like that I prefer to just use two tables and use the Parent ID as the relationship across the columns.
But it sounds like you may be talking about concatenating the Parent ID with a new Child ID, maybe worth considering the relationship route which will take away some complexity
Great video. Here a newbie of powerapps. I'm looking to achieve something similar to what you demonstrated in your video. In my case I have created an app that employees can use to report their absence from work. The app contains a form with basic information such as the employee's number and name, work area, etc.
What I am trying to achieve is that when the employee submits the absence form, there will be a new window with a confirmation number. This number must be the same number for 24hrs. After 24 hours the number should change for the new day. Is this something that can be achieved in powerapps?
Do you think my question could be material for another magnificent video of yours? Thanks in advance.
Hey, of course that is a great concept for a video I can add it to my list!
Kindly assist me to come up with a solution that would help me generate a unique ID. i have a list where one unique ID can have several entries how can i achieve this(i.e an ID has several Purchase Order Numbers (PO Numbers) related to it
This is relational data 101! expand your tables if there are 1:N (one to many) rows, create related tables, its not easy in SharePoint but possible, much easier in Dataverse
Great video!!! Here a newbie of powerapps. I'm looking to achieve something similar to what you demonstrated in your video. In my case I have created an app that employees can use to report their absence from work. The app contains a form with basic information such as the employee's number and name, work area, etc.
What I am trying to achieve is that when the employee submits the absence form, there will be a new window with a confirmation number. This number must be the same number for 24hrs. After 24 hours the number should change for the new day. Is this something that can be achieved in powerapps?
Do you think my question could be material for another magnificent video of yours?
:)
Hi, I had a question maybe you can solve it. If I have an excel file as the data source and I create an app. When the user adds his id he must be able to see only his data(specific fields, not all the fields say if I have 5 fields name, surname, id, course, class, and school. when the user inputs his id he would see only his name and surname ) a. How can I do this using powerapps? It would be great if you teach us this.
Thanks Kakan, this is certainly possible I tend to stear away from excel as a data source but I would be happy to do a video and show you how this could be possible!
@@Novalogix-ltd Thanks a Lot. I will be waiting for your video:)
Hey! Great video! I have a question. I want to make a unique id/ workorder number, which would auto generate work order number incrementally, so that every time I submit the form, it emails the recipient the new order number and report. You think there’s a way to do that?
Thanks, glad you enjoyed it!
There sure is, incrementing the number means we need to know the last submited work order so we need to be storing the submissions in a data source (SharePoint List, SQL or something else) SharePoint and SQL will have a primary Key (In SharePoint this is the ID field) which is automatically incremented every time a new item/row is added, we can use this or create our own work order number field.
If you use the built in ID field you just need to create a new item and the ID field will automatically have incremented, the Patch function can create a default Item and also returns the newly created item.
Set(NewItem, Patch('SharePointList',Defaults('SharePointList'))) -> Create a new item with default fields and set it to a variable
NewItem.ID -> Access the ID which has been automatically incremented by SharePoint to use in our app
OR
Using the below formula we can get the highest number in the field (sort all items by the field, descending and just use the first) and then all our app would need to do is add 1 to the number.
First(SortByColumns('SharePointList', "WorkOrderNumber", Descending)).WorkOrderNumber-> gives you the highest number in the workOrderColumn
Using Concatenate you could then also add in your own random number or text, the options are endless :)
I will add it to my list of videos for future!
Fluid SharePoint thanks for the reply. I understand that if there is a previous record stored somewhere, I can have the powerapps increment it. But let’s say, in my case, I created an app for inventory, which sends an email report (created using htmltext in powerapps) to the concerned department, I don’t have any previous data, nor do I want to extract it from anywhere, I want to natively work in powerapps. I have figured out everything, if I could get the work order number to auto increment, that would be perfect. But none the less, looking forward to your upcoming videos. Great work and good job!
@@knubbe Hi, you can get it to increment within the app but each time the app is loaded it needs to know the last number which was sent and the app cant be updated with this information in itself, the best and only way I know to do this is to at least have a log in a database(SharePoint List) and look it up when the app loads.
Having a log is always a good idea so that you can find out where if ever things go wrong or if users are telling you something didnt happen.
Great video, helped a lot! I'm from Brazil and I wish you success! congratulations.
You are welcome! I have a whole new set coming soon with updated content!
This is a great video. Is there a way add the initials from a display name field to the unique ID?
For sure, all we are doing is concatenating strings to make a string, you can use the User() function to get full name surname, you will need to get the first character on each string to bring it all together using Left(string, 1) on the full name and surname, if you don't get it let me know I can throw you a video!
How can we make it a default six digits "000000" then just incremental+1?
Hey! You can use this formula to add more digits Text("String", "000000") this will ensure you get 6 prefixed 0's!
Thanks a lot for this video!! Helped me so much
You are welcome! I do have some new and updated content coming soon so stay tuned!
Nice. Thanks for this. I think it suits my use case!
Great to hear, I have a nother video out next week that goes over another method of using Unique ID(s)!
The code is not available anymore. Could you upload it again? Thank you very much! :)
Hey, apologies! my website has moved, I am making all content available via my website very soon I will update the links in the video!
Great job !! Thanks for the video. Got my solution.
Great news! No problems :)
Superb.. This is not unique right, I mean there is no check to ensure the random number generated is unique and so this need not be unique
Hi, correct on its own it wont necessarily be 'Unique' although the more numbers you use the less chance of a duplication, I tend to use this technique in conjucntion with the unique ID provided by the data source (SP List ID or SQL ID) to make sure its 100% unique or in some situations generate a guid :)