I have created a flow that filters an excel tabled and get desired row in column. I am getting all values from row fine, but I would like to get all True values in that row.
My excel sheet and screen shot of flow here.
thx christian for your reply
When i am trying to put switch, i am getting error.. I am putting equal True...
The template validation failed: 'The template action 'Switch' at line '1' and column '7986' is not valid: the value 'True' specified for 'case' property in switch case 'Case' is not allowed. Only values of types string, number or a '@parameters()' expression that evaluates to a number or a string is allowed.'.
@usarif maeby i miss understhand so what you need is something like this in your output?
If is yes, please see my example
if no, and you want to do is get only the yes values per line you need to create a filter array per column, just exactly what you do.
so if you see my excel table below. I want to get all True Row values of Cloud row from Group Name column.
for example if i get column Group Name value Cloud, i would like to get App, Msg, Format, Desktop, Shared, Price because value is listed as True..
Check out new user group experience and if you are a leader please create your group
See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.
Many congratulations to the Season 1 2021 Flownaut Crew!
ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.