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

[Anonymous]

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.

[WarrenBelz]

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?

[Anonymous]

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]

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.

[Anonymous]

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]

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.

[Anonymous]

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

[WarrenBelz]

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?

[Anonymous]

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]

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.