Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Saving an excel attachment and creating a table ( need help SharePoint get file metadata and Sharepoint get file (properties only) )

(0) ShareShare
ReportReport
Posted on by 2

I learned that using a browsing method for the file path during table creation causes errors. This is because I replace the existing Excel file with a new one every day.

I quite don't understand what to put in the file identifier option in "get file metadata action" step 3step 3step 2step 2step 1step 1

However when I browse my file and run the flow it gives me an error saying "invalid request/ this resource does not exist"

For context, my Power App connects to a SharePoint list. I receive daily data updates through email attachments. Upon receiving a new attachment, I follow these steps:

  1. Save the attachment to a SharePoint folder (no issues encountered here).
  2. Create a table (encountering errors at this step).
  3. Delete all items from the SharePoint list (confirmed to work correctly).
  4. Add all rows from the created Excel table as new items in the SharePoint list (unable to test due to errors in step 2).

Any insights into the cause of the errors would be appreciated.

  • shravanimuthe Profile Picture
    2 on at
    Re: Saving an excel attachment and creating a table ( need help SharePoint get file metadata and Sharepoint get file (properties only) )

    This did not work for me. I am replacing the file everytime and i cannot browse and hardcode the file name.
    I am trying to figure out how to find the path dynamically for the file i just saved.

  • ManishSolanki Profile Picture
    15,085 Super User 2025 Season 1 on at
    Re: Saving an excel attachment and creating a table ( need help SharePoint get file metadata and Sharepoint get file (properties only) )

    Hi @shravanimuthe 

     

    Pls check if one of my previous solutions would help you here:

    Solved: Having trouble creating table - Power Platform Community (microsoft.com)

     

     

    If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

     

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

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 > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 566 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 516 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 492