web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Help required for Powe...

Power Apps

Answered

Help required for PowerApps updating DataVerse table from a collection

(0) Share

Report

Report

Posted on by Spikenaylor

18

I can create a record in the DataVerse table fine no issues there, but am struggling to update that same record.

Am also looking for the code to update all records but create new record if the record in the collection is not in the dataverse table.

I have been messing around with lots of code, but just cant get it to work for updating.

Create Record Code:

ForAll(
Collection,
Patch(
'DateVerseTable',
Defaults('DataVerseTable'),
{CollectionID: ThisRecord.CollectionID,
'Damaged': ThisRecord.'Damaged'
}
))

Edit Record Code:

ForAll(
Collection,
Patch(
LookUp(
'DataVerseTable',
CollectionID = ThisRecord.CollectionID
),
{'Damaged': ThisRecord.'Damaged'}
)
)

Edit Record code runs with no errors, but the table is not updated.

Cant understand why it doesn't update.

any idea help guidance would be appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

Verified answer

WarrenBelz 156,456 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Spikenaylor ,

Update should be as below

ForAll( Collection As aCol, Patch( 'DataVerseTable', LookUp( 'DataVerseTable', CollectionID = aCol.CollectionID ), {'Damaged': aCol.'Damaged'} ) )

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Spikenaylor 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Many thanks, that worked. I have seen this structure before, but why do we have redefine the Collection as another entity?

Was this reply helpful? Yes No
WarrenBelz 156,456 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Spikenaylor ,

As is a disambiguation operator and you have identical field names in the source and target.

Was this reply helpful? Yes No

Join the conversation