cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Berny
Level 8

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
Super User
Super User

Re: Rules with multiselect - can it work?

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
Super User
Super User

Re: Rules with multiselect - can it work?

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

Berny
Level 8

Re: Rules with multiselect - can it work?

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
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 238 members 6,490 guests
Please welcome our newest community members: