Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
Check out the New Agent Creator Community
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / Get rows from new crea...
Power Automate - Building Flows
Unanswered

Get rows from new created excel file in a sharepoint folder and move it to sharepoint list

(0) ShareShare
ReportReport
Posted on by Community Power Pla...

Dear all,

 

I appeal to your knowledges today in order to solve the flow I'm building !

 

I need to get attachment (excel file) from email > transfert these file to sharepoint folder > create and get tables from this file > transfert these tables to sharepoint list. 

 

The difficulty is to catch the information from a table which is unknown before the email reception and transfert it to a sharepoint list with dynamic content...

 

How could I move datas from a table which is unknown to SP list with dynamic content ?

 

Process : Receive email > move attachment to sharepoint folder > Get and create table > Get rows from table > move it to sharepoint list.

 

1 : Get attachments from email 

Image 1.jpg

 

2 : Create file in sharepoint folder

Image 2.jpg

 

3: Create and get tables from this file  :

image 3.jpg

 

4: List rows and move it to sharepoint list :

Image 4.jpg

 

Thanks a lot for your precious help !

KR,

Adrien

  • Dea_Xiaobai Profile Picture
    Dea_Xiaobai 4 on at
    Re: Get rows from new created excel file in a sharepoint folder and move it to sharepoint list

    hi @Anonymous 

    Have you solve your problem yet? I meet same problem with you now, hope you have fixed it already

  • Community Power Platform Member Profile Picture
    Community Power Pla... on at
    Re: Get rows from new created excel file in a sharepoint folder and move it to sharepoint list

    Hi Anthony,

    When I say unknown table, it is because the table could be not created yet, it is about tables arriving every month (with the same Metadata/headings of course) but it is more about recognizing when table arrive in SP file.

    The difficulty is to implement a system of recognizing future file in SP file and save its data to SP list.

    The flow is working, but I cannot get all the datas for the step "creating item" in SP list, I can only get the ID of the file but not the data inside...

    So I'm blocked at the step "creating item"...

    Thank you for your help,

    PS: Sorry for the delay of answering I was in vacation

    Kind regards,

    Adrien

  • AnthonyAmador Profile Picture
    AnthonyAmador 2,553 Super User 2025 Season 1 on at
    Re: Get rows from new created excel file in a sharepoint folder and move it to sharepoint list

    Hi @Anonymous 

     

    What do you mean when you say unknown table? if that means that the headings its going to be different all the time, it seems complicated to do, because all the dynamic content of the table will be different and depend on the excel file, or does the excel table and the SP list have the same headings? can you explain me.

     

    Also I want to know if the flow you share is working.

     

    Cheers. 

     

     

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

News and Announcements

Welcome to the Power Platform Communities
Check out the New Agent Creator Community

Quick Links

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans