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

[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.

[BCBuizer]

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.

[jimi_hendrix]

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

[Kristóf · Accepted solution]

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&" "))

[jimi_hendrix]

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