0

I am creating a Power Apps Canvas app. In this app I have a form that creates an item in a SharePoint list using a button: OnSelect "SubmitForm(Form1)". this creates the item but I want to also attach the consents of a table. The table data is stored in a collection and I want the data in the collection added to the item the form just created. I have an empty column in the SharePoint side called "Table Data" and I need to put the collection data into that items column

I have tried using the patch function but I'm not sure how to select the item the form just created. I can select the right SharePoint list but I'm not sure how to select the item.

Big O
  • 1
  • 1

1 Answers1

0

To reference the item created with Form1, you can use Form1.LastSubmit.

To attach tabular data to your SP record, I guess you have 3 options:

  1. Use the JSON() function to jsonify your data. This can then be stored as text in SharePoint. You cannot read this back into PowerApps, but you can use the json in Power Automate.
  2. You can come up with some sort of separator and save your results as delimited text. This is less preferable, but can be reused to some extent in Power Apps.
  3. If your data structure allows that, you can create a 1-N relationship with a second table to store the tabular data with external keys pointing to your form submission.
mmikesy90
  • 783
  • 1
  • 4
  • 11