web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Column value from one ...

Power Apps

Answered

Column value from one list as choice value into another list field

(0) Share

Report

Report

Posted on by Ape Awakening

301

I'm trying to submit check box value which I'm getting it from another list which is multi select .
My Item property is

ShowColumns(Filter(colequipment,ProfileType.Value = "Pump"),ProfileOption,ID)

My Checkbox OnCheck property

Collect(colPump,ThisItem.ProfileOption)

So , I have problem in Onuncheck Property Remove(colPump,ThisItem)

Please help just understand this

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (5)

Answers Img

Answers (1)

v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @apeawakening ,

Does the formula on uncheck not working?

Please try this.

RemoveIf(colPump,ID=ThisItem.ID)

Best regards,

Rimmon

Was this reply helpful? Yes No
Ape Awakening 301 on at

Like (0)

Report
Copy link

Link copied!

ID is not recognize . Since on click of my Oncheck is Collect(colPump,ThisItem.ProfileOption)

Was this reply helpful? Yes No
Verified answer

v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @apeawakening ,

If some value in ProfileOption may be duplicate, I'm afraid that you need to save ID to the collection as well. Otherwise, the formula may delete other items not ThisItem.

OnCheck.

Collect(colPump,ThisItem)

OnUncheck.

RemoveIf(colPump,ID=ThisItem.ID)

If value are all distinct, you can change the ID to ProfileOption.

RemoveIf(colPump,ProfileOption=ThisItem.ProfileOption)

Best regards,

Rimmon

Was this reply helpful? Yes No
Ape Awakening 301 on at

Like (0)

Report
Copy link

Link copied!

What should be the datacard Update property value ?

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @apeawakening ,

Please try this.

ForAll(colPump As C,{Value:C.ProfileOption})

Best regards,

Rimmon

Was this reply helpful? Yes No

Join the conversation