Share
Report
2I have a sharepoint list with a column for countries (drop-down multi-select choice) and number of countries (numbers).
So far I have been able to auto-populate # of countries based on the "Update Item" flow by inserting a length function and the dynamic content for the countries column
length(triggerbody()?['countries'])
| Countries | # of countries |
| Angola | 1 |
| Argentina, Brunei | 2 |
| Group (All countries) | 67 |
But I want to return a value 67 if "Group (All countries)" is selected.
I tried inserting an If function but it is not working for me. It is always giving me the false case which is the same formula above.
if(contains(triggerbody()?['countries'],'Group'),'67',length(triggerbody()?['countries']))
How can I get this formula working?
Categories:
All responses (
Answers (
