52
Hi All,
I want to make a power app using SharePoint List. There is a SharePoint self-generated ID column in Form 1, and i want that ID data to be filled by itself in the Form2 id column. Is there any way to do it?
Thank you in advance...
Hi @Hritikpatel317,
Assuming that the Forms are connected to separate lists and Form2 contains a custom number / text column (not the default ID column) to store Form1's ID, you can save the ID by adjusting the controls' Default property. (Default property of the DataCardValue of that particular column in Form 2) Depending on the requirement you may need 2 different approaches.
(1) Auto-fill number / text column on Form 2 with the last created record of Form 1
You will have to change the Default property of the Form Text Input control (DataCardValue) to:
Share
Report
All responses (
Answers (
Form1.LastSubmit.ID
Note: In case Form1 is on a different screen, you may want to temporarily save the ID when navigating and reference the variable instead.
//Navigate function
Navigate(Form2Screen, ScreenTransition.None, {locForm1Id: Form1.LastSubmit.ID})
//Default property of the Form 2 number / text column
locForm1Id
(2) Auto-fill number / text column on Form 2 with the displayed record ID of Edit Form 1
In this case you will have to copy the logic of Form 1's Item property in order to fetch the correct record. Let's say Form 1 Item's property is Gallery1.Selected. You can display this record's ID value in Form 2 by changing the Default property of the Form 2 Text Input (DataCardValue) to:
//<Form1 Item property>.ID
Gallery1.Selected.ID
If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.
Thanks!
