web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Need help patching yes...

Power Apps

Answered

Need help patching yes/no list entries while using a collection of IDs

(0) Share

Report

Report

Posted on by IamTrying

58

Hi guys,

I came along with the following problem:

I have collection (CollID) containing several IDs (these IDs are the linked IDs of a contact list).

Iam now trying to patch the yes/no column (called: "VI") in the contact list where the saved IDs of the collection are matched.

I tried:

ForAll(CollID;Patch(contact;LookUp(contact;ID=ID);{VI:true}))

However, that does not work. Does anyone of you have an idea?

Greetings René

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@IamTrying

To start, your formula has the ForAll backward. You are trying to use it like a ForLoop in some development language - which PowerApps is not. ForAll is a function that returns a table of records based on your iteration table and record schema.

It is more efficient to use the function as intended and will provide better performance.

In your formula, the ID=ID is what is causing your issue.

However, your formula should be the following:

Patch(contact; ForAll(CollID; {ID: ID; VI:true } ) )

There is no need to re-lookup record based on the ID...you already have the ID and that is all that Patch needs - the primary key!

This was also another extreme performance killer in your formula with the ForAll backward... not only was Patch needing to be instantiated many times, but each also needed a LookUp multiple times.

I hope this is helpful for you.

Was this reply helpful? Yes No
IamTrying 58 on at

Like
a
(1)

Report
Copy link

Link copied!

Hey RandyHayes,

that makes sense and it does work perfectly. Thank you so much!

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@IamTrying

No problem! Happy to help!

Was this reply helpful? Yes No

Join the conversation