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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / I want to take selecti...
Power Automate
Unanswered

I want to take selective data from an excel table coming to me each month from a system. i have create a flow for it but i am stuck in between, help me find solution

(1) ShareShare
ReportReport
Posted on by 8

my flow looks like, 

 

1. when a file is created (properties only) in share point library folder

2. Get Tables from the file above using identifier dynamic value in the file feild

3. compose ( to select first table name from output of step two)

4. List rows present in a table( table of a existing excel file where i need the data)

5. Filter array (filtered the rows in which i need to update the columns)

6. List rows present in a table (table which i received as step 2 and 3, I used identifier dynamic value again in the File field)

7. Apply to each( for each value of table in step4)

8. i need to put condition now... and i am stuck ,,, i have columns names available for the table in step4 in dynamic value list, but i dont have columns name available for the table i got from step 2, how to compare, 

9, once i do step no. 8, i need to proceed with " update row action for table from step 4, with specific information i need from Table from Step 2

 

Please Help 

 

Categories:
I have the same question (0)
  • Nived_Nambiar Profile Picture
    18,138 Super User 2026 Season 1 on at

    Hi @Kanchan12 

     

    well coming to the condition - could you explain bit more ?

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel
    Blog: Nived Nambiar's Blogs

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

     

  • Kanchan12 Profile Picture
    8 on at

    I am thinking to avoid condition as anyhow I have only selected rows from filter array, 

    for each row selected now i want to update the cells from the table i am getting from table coming from Step 2, 

     

    I am attaching word file with a picture of my flow. 

    i need to update status and den approval date from table coming from step 2, for which i am trying to use item function as i have applied in Key vlaue

  • Kanchan12 Profile Picture
    8 on at

    My item function is actually failing which is tring to fatch data from List of rows from Mflowreport ( Mflow report is actually a table coming from Compose action, which is the first table coming from Get tables action

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 481

#2
11manish Profile Picture

11manish 278

#3
David_MA Profile Picture

David_MA 276 Super User 2026 Season 1

Last 30 days Overall leaderboard