web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Patching a collection ...

Power Apps

Answered

Patching a collection to a Dataverse table

(0) Share

Report

Report

Posted on by NaivePowerApper Microsoft Employee

App creates a collection by filtering a Dataverse table:

ClearCollect(ExampleCollection,Filter(ExampleDataverseTable,ExampleCoumnValue=ExampleValue))

The app both updates existing rows and adds new rows to the collection. The Collection is then patched back to the Dataverse table.

Patch(ExampleDataverseTable,ExampleCollection)

For adding new rows this seems to work fine. However, as soon as I edit an existing row the patch action generates a Network error.

Is there a straightforward way to resolve this issue?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

v-bofeng-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @NaivePowerApper ,

Because the collection contains some read-only fields in ExampleDataverseTable, when you use it to update the data source, PowerApps thinks that you also need to modify these read-only fields. The solution is to cull these read-only fields.

ForAll( ExampleCollection, If( IsBlank( LookUp(ExampleDataverseTable,Name=ExampleCollection[@Name]) ), Patch( ExampleDataverseTable, Defaults(ExampleDataverseTable), ThisRecord ), Patch( ExampleDataverseTable, LookUp(ExampleDataverseTable,Name=ExampleCollection[@Name]), { Column1:ThisRecord.Column1, Column2:ThisRecord.Column2 } ) ) )

Best Regards,

Bof

Was this reply helpful? Yes No
NaivePowerApper Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks, this was super helpful.

I messed around with it a little more. It appears that it's possible to achieve the same thing without the ForAll loop by using ShowColumns.

Patch(ExampleDataverseTable,ExampleCollection,ShowColumns(ExampleCollection,"ExampleCollumn1","ExampleCollumn2"))

Was this reply helpful? Yes No

Join the conversation