Patch function not working in power apps while updating the data to list

(0) Share

Report

Posted on by Susheel3112

Hi Group Members,

I am having an issue with power apps form,

I have three forms. Requestor form, vendor form and purchase form. I have attachment in the vendor form(second form).

On the patch function, I am submitting the data to the list. When I Click on submit button from the third form(Purchase form), I am submitting the data to the SharePoint list by using Patch command.

The problem here is data is getting submitted only from Form2 and Form3, but not from Form1.

I have 1 people picker field, couple of text boxes and couple of drop downs. I don't have any attachments on the form.

Did any had this type of similar issue? If so, Can any one provide me some insight on how to fix this issue. I have been trying from past 3 days but no luck.

Any suggestions or help be would be really appreciated.

Thanks in Advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Susheel3112

Check out @RandyHayes video here

https://www.youtube.com/watch?v=2E4FXNPLVXw for a better way.

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Susheel3112 ,

Do you want to add one item by these three forms? If so, the formula could be:

Patch(DataSource,Defaults(DataSource),Form1.Updates,Form2.Updates,Form3.Updates)

Could you please show me your formula?

Best Regards,

Bof

Was this reply helpful? Yes No
Susheel3112 4 on at

Like (0)

Report
Copy link

Link copied!

Patch(Requests,Form3.Updates,Form4.Updates,SharePointForm1_1.Updates);

Was this reply helpful? Yes No
Susheel3112 4 on at

Like (0)

Report
Copy link

Link copied!

Thanks for your response! will check the video.

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Susheel3112 ,

If you want to add a new record, the formula should be:

Patch(Requests,Defaults(Requests),Form3.Updates,Form4.Updates,SharePointForm1_1.Updates);

If you want to update a record, the fomula should be:

Patch(Requests,TheSpecifcRecord,Form3.Updates,Form4.Updates,SharePointForm1_1.Updates);

Best Regards,

Bof

Was this reply helpful? Yes No