Answered

How to auto generate random ID while displaying it on every screen and finally gather all added items under one ID

(0) Share

Report

Posted on by Shenawi23

Hello,

I am trying to auto generate random ID where the Customer will input several orders on the second screen. I want to show the ID on all screen and at the end display on a table the orders and the full order ID as shown below.

Main (Screen 1):

- Two sections, Top section is to receive the data and display it and open order request. Bottom section is to display the end result data on a table.

Main_View (Screen 2):

- Two sections, Top section is to display data ontop including the ID. Bottom section is a table and a button to add Items (Order).

Detail (Screen 3):

- Input Title and attachments. Will display the Order ID again

Steps:

step 1: Receive all information then click create

step 2: it should show the auto generated ID

Step 3: On screen 2, input data but the ID will display as it recalls it from screen 1 (can't be edited)

Step 4: Submit for Approval

Step 5: Directed back to Screen 1 and display on a table below of each order and the same ID number for all orders.

I hope someone can help me. I am just unable to generate the ID while displaying on a table and every single screen. If my question or request does not make any sense then please do ask.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

iAm_ManCat 18,228 Most Valuable Professional on at

Like (1)

Report

Are you using SharePoint? And if yes, are you submitting your step1 using a form? If yes, then you can use FormName.LastSubmit.ID to get the unique row ID for that item, set that to a variable, and then use that everywhere else in the App.

You will need a child list that has a column for referencing the parent list's ID field (FormName.LastSubmit.ID) as a reference column - that way you can filter or reference and rows relating to the parent Order, inside which there are multiple related child items(other orders).

Was this reply helpful? Yes No
Shenawi23 13 on at

Like (1)

Report

Thank you for your response first and foremost.

I just recently started using power apps so am not exactly very familiar with the terms. Could you please elaborate a bit?

Was this reply helpful? Yes No
iAm_ManCat 18,228 Most Valuable Professional on at

Like (1)

Report

Hi,

If you are new to Power Apps and wanting to build what you've described, you will need a bit more knowledge to help you with that and my explaining it won't resolve that - I would highly recommend looking at this collection of learning resources (I recommend this to everyone, regardless of experience):

Microsoft Power Platform: Learning Resources | Microsoft Power Apps

You can also look at https://learn.microsoft.com and follow through the the introduction courses there to get a good foothold on the technology 🙂

If you have any specific questions about the App you've built then write specific questions on the forums, that will guarantee you get a more exact answer rather than a set of steps that you need to follow.

Hope this helps! Feel free to ask any specific questions if you don't understand anything,

Cheers,

Was this reply helpful? Yes No
Shenawi23 13 on at

Like (1)

Report

Thank you for your help. I will look into what you have sent me and try to learn as I go.

Was this reply helpful? Yes No