IsMatch combined with ThisItem

(0) Share

Report

Posted on by Rapaille

156

Hello,

In my app I have a dropdown list with 6 options ('A - ' - 'F - '). Multiple options can be chosen.

On the Browse Screen I want to have a icon changed based on which options were selected. I have the below formula, but receive a error for '.Value'. Is there someone who can help me with below?

Thank you very much in advance for your cooperation.

If(IsMatch(ThisItem.'Resultaat warmteproef'.Value,"C - ",Contains)=false),Icon.CheckBadge,Icon.CancelBadge)

Kind regards,

Hans

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

StretchFredrik 3,395 Super User 2025 Season 2 on at

Like (0)

Report

Is the column.value in this case a string or what is it?

Was this reply helpful? Yes No
Rapaille 156 on at

Like (0)

Report

Sorry, I'm not very experienced with PowerApps. Still learning.

It is connected to a SharePoint list column, type is choice. Does this answer your question?

Was this reply helpful? Yes No
StretchFredrik 3,395 Super User 2025 Season 2 on at

Like (0)

Report

The issue is that your column is multi choice, thats why its complaining 😃 You can fix this by getting the first value or loop them.

Was this reply helpful? Yes No
Rapaille 156 on at

Like (0)

Report

I don't think the first value solution is feasible for me. What do you mean with loop?

Was this reply helpful? Yes No
StretchFredrik 3,395 Super User 2025 Season 2 on at

Like (0)

Report

With the Forall() function

https://docs.microsoft.com/sv-se/power-platform/power-fx/reference/function-forall

Was this reply helpful? Yes No
Verified answer

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like (0)

Report

Hi,
Please try using below formula -
If(IsMatch(Concat(ThisItem.'Resultaat warmteproef'.Value, Value, ",") , "C - ", Contains) = false ,Icon.CheckBadge,Icon.CancelBadge)

Was this reply helpful? Yes No
Rapaille 156 on at

Like (0)

Report

Yes, this one works. Thank you very much.

Was this reply helpful? Yes No
Rapaille 156 on at

Like (0)

Report

Thank you for your help, issue is solved with NandiniBhagya20's solution.

Was this reply helpful? Yes No