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?
I get the message stating that "Cannot use table values in this context"
Go to Solution.
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 -
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 GuyPowerApps and Flow MVPBlog | 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
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.
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand