Answered

Comparing selections from a multichoice SP list column to another multichoice column on the same list

(0) Share

Report

Posted on by jimi_hendrix

The title says it all but to elaborate I will go into detail.

	Reviews Needed	Reviews Completed
Item 1	ABC,DEF,GHI	ABC
Item 2	ABC,DEF,GHI	GHI,DEF,ABC
Item 3	ABC,GHI	DEF,GHI

This should outline the majority of the use cases.

As you can tell, Item 2 should be good to go and I would like to flag this as good to go.. For now as long as I have a condition that spits out "GOOD", that is all I would need.. The other two items are not good. The output of Item 1, should ready, that Review DEF and GHI are still needed. While Item 3 should spit out Review ABC is still needed..

Any help with this to incorporate into powerapps canvas would be greatly appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

BCBuizer 22,579 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @jimi_hendrix ,

I don't have time to test this, but my first try would look like this:

IsEmpty( Filter( ThisItem.'Reviews Needed', Not(Value in ThisItem.'Reviews Completed') ) )

Basically it uses a filter to check if there's anything in 'Reviews Needed' that is not in 'Reviews Completed'. If this returns no Items, meaning all values in 'Reviews Needed' are also in 'Reviews Completed', the IsEmpty function will return true.

Was this reply helpful? Yes No
jimi_hendrix on at

Like (0)

Report
Copy link

Link copied!

Thanks for the quick reply @BCBuizer ,

Unfortunately this didnt work. This always returns false.. even when there is a single match or all match.

This is definitely a different direction then I was expecting so I will investigate further but if you know what could be tweaked on the above, let me know..

Thanks

Was this reply helpful? Yes No
Verified answer

Krzysztof Borkowski Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Lbl_review_needed.Text = Concat(Sort(ThisItem.'Review needed',Value),Value," ")
Lbl_review_complated.Text =Concat(Sort(ThisItem.'Review Completed', Value),Value, " ")
Lbl_ok_not_ok.Text = If(Lbl_review_needed.Text=Lbl_review_completed.Text,"Good 👍🏻","Review: "&Concat(Filter(ThisItem.'Review needed'.Value,Not(Value in ThisItem.'Review Completed'.Value)),Value&" "))

Was this reply helpful? Yes No
jimi_hendrix on at

Like (1)

Report
Copy link

Link copied!

Thank you both.. @BCBuizer and @Kristóf

Was this reply helpful? Yes No