ForAll in collection Patch to CDS

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I am confused formula with for all and patch.

I have a collection "list" and CDS entity "shop"

here is my scenario.
"list" is created by a gallery check box.

gallery item"shop"

check box on select :Collect(list,ThisItem)

I would like to update CDS "shop" field ”rep” (text) if data is in "list".

I have created the following formula but this is not working.

ForAll(list,

Patch(shop,LookUp(shop,cr9d1_code=cr9d1_code),{cr9d1_rep:ComboBox3.Selected.Value}))

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Reimi Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
try this:

ForAll(list As temp, Patch(shop,LookUp(shop,cr9d1_code=temp.cr9d1_code),{cr9d1_rep:ComboBox3.Selected.Value}))

if the function above doesn't work, please let us know the detail of your issue (like error message)

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@Reimi

thank you for your help.

I have tried but unfortunately it did not work.
It looks like its working but nothing changed.

I have change a little and tried but it also did not work.
ForAll(list As temp, Patch(shop,LookUp(shop,cr9d1_shopid=temp.cr9d1_shopid),{cr9d1_rep:ComboBox3.Selected.Value}))

There was no underline and error massage.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@Reimi

I have checked my data and I found that One record (looks first data) was patched but it was not the same "code".
Look to code on my collection, there was no data to the patched One record.

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

Like
a
(0)

Report
Copy link

Link copied!

I guess "list" collection doesn't collect the record correctly.

Can you please give us the screenshot of your app?

How do you collect "list"?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@Reimi

Please check this.
I collect _list by checking the checkbox in my gallery.
My gallery is made from the filtered CDS entity "shop" which I am going to patch to.

patch button

Was this reply helpful? Yes No