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 / Extract data from exce...
Power Automate
Unanswered

Extract data from excel in sharepoint whenever a new excel file is created in folder

(0) ShareShare
ReportReport
Posted on by 22

Hello to all!

 

I am new to power automate and is trying to extract data whenever a new excel file is created in a sharepoint folder. The excel files are in table format (Table1). 

 

For the below flow, which option should I use for the File location?

 

Thank you.

 

Daniel2023_1-1689137155713.png

 

 

Categories:
I have the same question (0)
  • Verified answer
    v-xiaochen-msft Profile Picture
    on at

    Hi @Daniel2023 ,

     

    Please try this:

    vxiaochenmsft_0-1689143250750.png

    vxiaochenmsft_1-1689143263698.png

    vxiaochenmsft_2-1689143280710.png

    vxiaochenmsft_3-1689143299489.png

     

    Best Regards,

    Wearsky

  • Daniel2023 Profile Picture
    22 on at

    Thank you 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 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard