Getting True row values from excel sheet

(0) Share

Report

Posted on by usarif

195

Hi All,

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.

[

{

"@odata.etag": "",

"ItemInternalId": "75af9c60-c3ad-4e69-9992-6e851da52328",

"Group Name": "Cloud",

"App": "true",

"sys": "",

"Msg": "true",

"Column": "",

"Format": "true",

"Desktop": "true",

"shared": "true",

"Price": "true",

"Special": "",

"Club": "true"

}

]

============================================================

just looking for sort only True values from row..

thanks

All responses (5)

Answers (0)

ChristianAbata 8,949 Most Valuable Professional on at

Like (0)

Report

Re: Getting True row values from excel sheet

ok, @usarif you need to create a filter query per row
usarif 195 on at

Like (0)

Report

Re: Getting True row values from excel sheet

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..
ChristianAbata 8,949 Most Valuable Professional on at

Like (0)

Report

Re: Getting True row values from excel sheet

@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.
usarif 195 on at

Like (0)

Report

Re: Getting True row values from excel sheet

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.'.
ChristianAbata 8,949 Most Valuable Professional on at

Like (0)

Report

Re: Getting True row values from excel sheet

@usarif you need to add a swich case action to get the data from avery column