cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Berny
Kudo Collector
Kudo Collector

Rules with multiselect - can it work?

I am trying to setup a rule on a multiselect box (SharePoint Choice field). Does anyone know if this would work or what the condition of the rule could be?

 

rule.PNG

 

I get the message stating that "Cannot use table values in this context"

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @Berny

 

My response is based on whatever I could infer from your question, as I wasn't ver sure of the functionality that you are trying to achieve.

 

I am not sure if there is a direct way to do this, but you can use this formula -

 

CountIf(DataCardValue10.SelectedItems,Value="Termination")=1

Instead of the data card's .Update property, I have used the Combo Box's .SelectedItems property. The above formula counts all the records where at least one of the choice selected is "Termination".

 

Let me know if you have any further questions.


Vivek Bavishi aka That API Guy
PowerApps and Flow MVP
Blog | Twitter | YouTube | Community Profile | GitHub



If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2

Hi @Berny

 

My response is based on whatever I could infer from your question, as I wasn't ver sure of the functionality that you are trying to achieve.

 

I am not sure if there is a direct way to do this, but you can use this formula -

 

CountIf(DataCardValue10.SelectedItems,Value="Termination")=1

Instead of the data card's .Update property, I have used the Combo Box's .SelectedItems property. The above formula counts all the records where at least one of the choice selected is "Termination".

 

Let me know if you have any further questions.


Vivek Bavishi aka That API Guy
PowerApps and Flow MVP
Blog | Twitter | YouTube | Community Profile | GitHub



If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you very much that worked out perfectly. 

 

It has definately been an interesting transition moving to PowerApps and Flow to design forms. I think it will be better but it sure takes some work to switch over.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,506)