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

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Need to only add rows ...
Power Automate
Unanswered

Need to only add rows of one particular column value

(0) ShareShare
ReportReport
Posted on by 5

Hi Everyone, 

I've got a flow which involves calling a Graph API, parsing the JSON and then adding the items(using for each) as rows into an excel table. However I want only the items that have one particular attribute value(for example , for JSON data containing Employee data, I want to only add the employees that have nationality as "UK") to be added into excel as rows in the table.

 

How can this be done ?

Categories:
I have the same question (0)
  • v-xiaochen-msft Profile Picture
    on at
    Re: Need to only add rows of one particular column value

    Hi @Pranaka ,

     

    Do you want to filter records?

    Please try to use filter array action.

    vxiaochenmsft_0-1718848189058.png

     

    Best Regards,

    Wearsky

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 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard