You are welcome! I have a whole new set coming soon with updated content!

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

Hey, of course that is a great concept for a video I can add it to my list!

Great to hear, I have a nother video out next week that goes over another method of using Unique ID(s)!

Great news! No problems :)

:)

You are welcome! I do have some new and updated content coming soon so stay tuned!

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.

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:)

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 :)

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!