Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

pull data from excel document in onedrive folder with a new document each day

(2) ShareShare
ReportReport
Posted on by

I have a onedrove folder with a flow that adds an excel document each day. I need to pull data from the new excel file added each day. The file name changes each day with the layout being the same. 

 

flow 1.PNGflow 2.PNG

Categories:
  • Re: pull data from excel document in onedrive folder with a new document each day

    Hey, @Anonymous!

     

    Thank you for posting on the Flow Community Forum! It appears as though would like some more information in order to further assist you properly with your issue. Please share any additional information that was requested in order to decrease the amount of time that it will take for you to be assisted!

     

    Thank you for being an active member of the Flow Community!

     

    -Gabriel
    Flow Community Manager

  • v-yamao-msft Profile Picture
    v-yamao-msft on at
    Re: pull data from excel document in onedrive folder with a new document each day

    Hi @Anonymous,

     

    Do all the files have a table with the same name, say Table1?

     

    If yes, please try the following configuration. I am trying to get all the rows from the newly added file, then insert the rows to a SharePoint list.

     

    The flow is triggered by When a file is created, then use the Excel action Get rows. When configuring this action, please make sure select dynamic content File identifier for the File name, then enter a custom value of the common table name in Table name field.

     

    Adding an Apply to each, get Value from the action Get rows, selecting the SharePoint action Create item. In the Title field and Startdate field, enter the following code:

    item()?['name']
    item()?['date']

    1.PNG

     

    Please take a try with it on your side.

     

     

    Best regards,

    Mabel Mao

  • MarkStokes Profile Picture
    MarkStokes 561 on at
    Re: pull data from excel document in onedrive folder with a new document each day
    What is the structure of the file name? Is any of it consistent? I’ll take an assumption that the file name is the same appened with a unique iderifier like a number or a date.

    If that is the case then you can trigger your Flow when a new document is added to your OneDrive account and then run a Condition that checks if the file name “starts with” a certain string value.

    -Mark

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard