Answered

Update multiple records in SharePoint List from PowerApps EditForm including an attachment

(0) Share

Report

Posted on by LAIKSAYY3

Hi Guys,

I intent to update multiple record in SharePoint List, based on the RequestNo matching the entered data in EditForm in Powerapps. Single record gets updated using the following query, but whatif, we have many RequestNo in SharePoint List??

1. Can we use Updateif or ForAll function but the data I am going to update is from a Form not Gallery!

2. Secondly, I also need to update/upload the same attachment, if there are multiple records, how can I include it in the ForAll loop or updateif loop?

To update a single record, following is the code, working perfectly:
Patch('POAs List',LookUp('POAs List',RequestNo = RequestNo_DataCard1.Default),
{
'POA No.': DataCardValue73.Text,
'Issuance Date':DateValue(IssuanceDt.Text,"fr"),
'Expiration Date':DateValue(DataCardKey76_1.Text,"fr"),
});
SubmitForm(Form4_1); /*For Attachment*/

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@LAIKSAYY3, regarding your first question: if the request no is not something unique, so it can be shared across multiple records, the UpdateIf() should do the trick:

UpdateIf('POAs List', RequestNo = RequestNo_DataCard1.Default, { 'POA No.': DataCardValue73.Text, 'Issuance Date':DateValue(IssuanceDt.Text,"fr"), 'Expiration Date':DateValue(DataCardKey76_1.Text,"fr"), })

This will update all records with that request number.

I hope this helps!
LAIKSAYY3 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanx Laurens for your prompt response.
The RequestNo field in the SharePoint List is not unique definitely, there are many RequestNo.
I will use the UpdateIf,, however, I am worried for the attachment to be uploaded for each record being updated. How do I do that?
Verified answer

LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@LAIKSAYY3 after some testing I have found a way to do this, it will require 2 UpdateIf statements.
One to update the fields (see above) and one to add the attachments. However, please make sure that your form mentioned as 'FormName' is on DisplayMode.New and only the attachment datacard is shown.

Please try the following code:

//Update fields UpdateIf('POAs List', RequestNo = RequestNo_DataCard1.Default, { 'POA No.': DataCardValue73.Text, 'Issuance Date':DateValue(IssuanceDt.Text,"fr"), 'Expiration Date':DateValue(DataCardKey76_1.Text,"fr"), }) //Add attachments UpdateIf('POAs List', RequestNo = RequestNo_DataCard1.Default, FormName.Updates)

If this solves your question, would you be so kind as to accept it as a solution.
Thanks!
LAIKSAYY3 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanx Laurens! it has done perfectly! 😀