cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
usarif
Resolver I
Resolver I

Getting True row values from excel sheet

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.

flow.png

[
  {
    "@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
5 REPLIES 5
ChristianAbata
Super User II
Super User II

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



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

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.'.

 

flow1.png

@usarif  maeby i miss understhand so what you need is something like this in your output?

all.PNG

 

If is yes, please see my example

 

alls2.PNG

 

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.

 

 



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

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..

excel.png

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



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Users online (58,927)