web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Use PowerApps to creat...
Power Apps
Answered

Use PowerApps to create SharePoint list form to view data in repeating table

(0) ShareShare
ReportReport
Posted on by Community Power Pla... Microsoft Employee

Hi,

 

I am using PowerApps to create a Form in PowerApps and I created a repeating table. After the user inserts, it will be saved into a SharePoint List but the problem is when the ID in the Sharepoint List is different than the User's ID.

 

For Example, 

Image001 is the user list and Image 002 is the list that the user inserted the data in the table. 

As I want the ID in Image 002 to be the same as the User's ID in Image 001.

Is it possible to make ID in a SharePoint List matches with the User ID?

 

Thank you.

 

image002.png
image001.png
Categories:
Building Power Apps
I have the same question (0)
  • WarrenBelz Profile Picture
    WarrenBelz 154,494 Most Valuable Professional on at

    Hi @Anonymous ,

    Firstly, the ID in a SharePoint list is generated by SharePoint sequentially starting at 1 and progressing as records are added. If you are adding to another list, it will have its ID created the same way - in the order that the record is created. What are you referring to as the User's ID?

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    Hi @WarrenBelz,

    Thank you for the reply,

     

    As based on the two images, I want the ID in Image 001 (48,61,64,65) to be the same as the ID in Image 002 (44). Now, I have Patched by using this formula:

     

    Patch('Purpose of data extraction',{Title:TextInput1.Text, ID:'Request Form'.LastSubmit.Id})

     

    When submitting the form, it doesn't show the ID. How can I solve this problem.

     

    Thank You

     

  • WarrenBelz Profile Picture
    WarrenBelz 154,494 Most Valuable Professional on at

    Hi @Anonymous ,

    You cannot change an ID number in SharePoint. It is the unique identifier of the record and the system simply will not allow data to be written to it.

    If you want a reference number, create another Numeric column (I call mine IDRef to match documents to the list item they belong to) and Patch to that.

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

     

     

     

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    Hi @WarrenBelz ,

    Thank you for your reply.

     

    I created a numeric column for ID in image 001  but when I submit the form it does not show up in the Sharepoint List as I hope that I can bring the User ID which is automatically generated in Image 002 into the created numeric ID column in Image 001.

     

    As the table is been patch before the submit the Sharepoint List form.

     

    Thank you

  • WarrenBelz Profile Picture
    WarrenBelz 154,494 Most Valuable Professional on at

    OK @Anonymous ,

    Firstly, you have to tell PowerApps what to Patch - for a new record

    Patch(
 'Purpose of data extraction',
 Defaults('Purpose of data extraction'),
 {
 Title:TextInput1.Text, 
 YourNewIDName:'Request Form'.LastSubmit.Id
 }
)

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

     

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    Hi @WarrenBelz ,

    Thank you for the reply,

     

    I tried the formula that you provide and I added the custom ID Column but is still not showing.

    the 'table' image is the repeating table that I am using and it is in the 'Submit Form' where the User ID will be generated after the user submits the form. 

    As I go back to the 'Purpose of Data Extraction' list it does not show the ID.

     

    Thank you

     

    Submit form.PNG
    table.PNG
  • WarrenBelz Profile Picture
    WarrenBelz 154,494 Most Valuable Professional on at

    Thanks @Anonymous ,

    The formula will work if you have the value 'Request Form'.LastSubmit.Id available - it is a simple Patch submitting two fields to a new record. You might note that the LastSubmit.Id will only work in the current session and will only display the ID of the last record submitted by the form using the SubmitForm command.

    It this run in the same command sequence as the SubmitForm of the primary record or is it run afterwards from another control?

     

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    Hi @WarrenBelz,

    Thank you for your reply.

     

    I have the value 'Request Form'.LastSubmit.Id

    The sequence of the form is when the user inserts the data into the repeating table once they clicked save, it will automatically patch the data in the repeating table and that is before the user submits the form.

     

    Thank you

  • WarrenBelz Profile Picture
    WarrenBelz 154,494 Most Valuable Professional on at

    Thanks @Anonymous ,

    Just so I have not missed anything, am I correct in assuming

    • You are using the code below (and have replaced my reference with your field name)
    Patch(
 'Purpose of data extraction',
 Defaults('Purpose of data extraction'),
 {
 Title:TextInput1.Text, 
 YourNewIDName:'Request Form'.LastSubmit.Id
 }
)
    • You have the 'Request Form'.LastSubmit.Id and can see it (suggest a label on the screen) before the code is run.
    • There is data in TextInput1.Text
    • There is no new record being added to the List 'Purpose of data extraction' which has a Text field Title and a Numeric field which you have referenced where I have YourNewIDName.

    There has to be something missing here if this is the case - can you please confirm all of this.

     

     

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    Hi @WarrenBelz 

     

    Thanks for your reply,

     

    The Patch will be activated once the user has inserted into the repeating table as I created a button for the table row and  There is a new record in the List List 'Purpose of data extraction' which has a Text field Title but does it show the ID that based on User ID in the 'Request List'.

     

    Is it because of the Patch code executed before the user the form?

     

    Thank you

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.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the February Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 549 Most Valuable Professional

#2
Kalathiya Profile Picture

Kalathiya 225 Super User 2026 Season 1

#3
Haque Profile Picture

Haque 224

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans