web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / get all values from rows
Power Automate
Unanswered

get all values from rows

(0) ShareShare
ReportReport
Posted on by 220

folks,

     I have an excel document in SharePoint library as example below. I would like to get all rows which has values on selective department column. For example if i trigger Finance under department, the value i would like to get app1, app3, app4 not a empty value.

table.png

 

I am getting value from column if HR match, but i am getting all values instead just check

flow.png

 

Categories:
I have the same question (0)
  • yashag2255 Profile Picture
    24,769 Super User 2024 Season 1 on at

    HI @usarif 

     

    The list rows present in a table action, gets you the entire row that matches the creiteria that you have set in the list rows action. After that, you can create a variable to populate it with the names of the columns that have check boxes using conditions to check if the column name is empty or not for that row. 

     

    There is no direct way to get the non empty cells (with the x mark) for a particular row. 

     

    Hope this Helps!

    Hi @Anonymous 

     

    Can you check this post here: https://docs.microsoft.com/en-us/ai-builder/flow-text-recognition 

     

    You can see that the "base64encoded" : string() is the correct format to pass as the parameters. Note that if you are passing the json payload, it needs to have a proper key and value that is not being passed in our flow. Also, you can get rid of the 'D' from the parse json. It is not the correct way to pass the argument. 

     

    The error is at the predict action only and should be resolved if you follow the above. 

     

    Hope this Helps!

    If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

  • usarif Profile Picture
    220 on at

    Hi  

      Thanks for your reply. Is it possible you can show screen shot. I am trying to do condition but value is not giving me back.

     

    Also, is it possible to get from ODATA filter?

  • usarif Profile Picture
    220 on at

    if i ran filter array, i am getting body like this, is there way to filter out only listed true value?

    [
    {
    "@odata.etag": "",
    "Adobe Acro Pro": "",
    "Adobe": "",
    "AHA": "",
    "Availity": "",
    "Visio": "true"
    }
    ]

  • usarif Profile Picture
    220 on at

    Anyone??

     

  • usarif Profile Picture
    220 on at

    hi super user,

        I was able to get all selected column but can't put together to check if column list as true or not. if i put condition, i am not able to check each column...

    flow.png

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard