Merge Duplicates and Patch all as one

(0) Share

Report

Posted on by Dinerz

112

Hi Smart People,

My gallery is reading from a SharePoint list and the 1st column called "Title" has several duplicates. I do not want to see duplicate values in the Gallery but I also need to patch the selected and all the duplicates with the same data.

Gallery:

ForAll(Distinct(SharePointList1,Title),LookUp(SharePointList1,Title = Value))

I managed to filter my Gallery to NOT show any duplicates, but when I select a single item and Patch, it only Patches the 1st row in the ShhrePoint list and I need it to Patch all the Titles with the same data.

Button to Patch:

Patch(SharePointList1, Gallery1_1.Selected, {'Key Deliverables': true})

Any advice or guidance will be appreciated?

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-jefferni Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Dinerz ,

It's due to the Patch function, the second parameter defines which item to update. So, please try below formula:

Button to Patch:

UpdateIf(SharePointList1, Title = Gallery1_1.Selected.Title, {'Key Deliverables': true})

Best regards,

Was this reply helpful? Yes No