Announcements
I have a powerapps form that connects to a sharepoint list sends data to sharepoint list. I need to add an id column to the sharepoint list and show that in the powerapps as an autonumber so that the id is not entered through the powerapps. Please let me know.
@dataverse
SharePoint already has an ID that automatically augmented by 1 when a new record is created. It is metadata that can't be edited by the user.
Can u pl send a screenshot of the auto number.
I found it. Thanks.
I have 2 forms in the powerapps that is connected to one single sharepoint list. The first form has the id field(and the value shows up in the form1) from sharepoint and has a save button. When I click on the save button it submits the form and inserts a row into the sharepoint list. But I have form2 that needs to update the current row(using id of form1 or the id field can be displayed in form 2 with the same value so that it updates the same row) that form1 is using.
Default property of datacardvalue is to display the id field.
If(Form1.Mode = New,Last(sharepointlist).ID+1,Parent.Default)
Please specify the best way to update the same row that form1 is using. The fields in form 1 and form2 are different.
In OnSuccess of form1: Set(var, Form1.LastSubmit.ID)
In Update property of the ID card on Form2:
Coalesce(var,Parent.Default)
The coalesce function gives a data type error. The Id field is right now a text field.
The error is fixed. BUt when I run the form2 the value in the id card is 0.
when I run the form1 the value in the id card is 12.
This is what I updated.
In default property of the ID card value on Form2:
Also it is possible to not include the id card value in form2 , but still refer to id card value of form1 and use it for the update of form2 content into the same record as form1
Please let me know.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 324 Most Valuable Professional
11manish 193
Valantis 138
