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
@evandrofreire7646 Жыл бұрын
Great video, helped a lot! I'm from Brazil and I wish you success! congratulations.
@Novalogix-ltd18 күн бұрын
You are welcome! I have a whole new set coming soon with updated content!
@cheriewong94702 жыл бұрын
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!
@Novalogix-ltd2 жыл бұрын
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
@OLDSCHOOLHIPHOP2 жыл бұрын
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.
@Novalogix-ltd2 жыл бұрын
Hey, of course that is a great concept for a video I can add it to my list!
@sistex37298 ай бұрын
This is a great video. Is there a way add the initials from a display name field to the unique ID?
@walterwego13963 жыл бұрын
Nice. Thanks for this. I think it suits my use case!
@Novalogix-ltd3 жыл бұрын
Great to hear, I have a nother video out next week that goes over another method of using Unique ID(s)!
@abhiseksahoo80403 жыл бұрын
Great job !! Thanks for the video. Got my solution.
@Novalogix-ltd3 жыл бұрын
Great news! No problems :)
@jfryendaya4 ай бұрын
How can we make it a default six digits "000000" then just incremental+1?
@OLDSCHOOLHIPHOP2 жыл бұрын
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?
@Novalogix-ltd2 жыл бұрын
:)
@Ray-gm1to Жыл бұрын
Thanks a lot for this video!! Helped me so much
@Novalogix-ltd18 күн бұрын
You are welcome! I do have some new and updated content coming soon so stay tuned!
@knubbe4 жыл бұрын
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?
@Novalogix-ltd4 жыл бұрын
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!
@knubbe4 жыл бұрын
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!
@Novalogix-ltd4 жыл бұрын
@@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.
@kakanadwani85253 жыл бұрын
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.
@Novalogix-ltd3 жыл бұрын
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!
@kakanadwani85253 жыл бұрын
@@Novalogix-ltd Thanks a Lot. I will be waiting for your video:)
@sreeniv093 жыл бұрын
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
@Novalogix-ltd3 жыл бұрын
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 :)
@prewpow3115 Жыл бұрын
The code is not available anymore. Could you upload it again? Thank you very much! :)
@Novalogix-ltd18 күн бұрын
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!