A quick video showing you how to generate a Unique ID in your Power App Code can be found at: www.fluid-sharepoint.com/gene... LinkedIn - / colin-cook Twitter - / fsharepoint Royalty Free Music from www.bensound.com
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
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! 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.
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?
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!
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 :)