Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

Dynamically get an excel file

(0) ShareShare
ReportReport
Posted on by 377

Hi there

I am wanting to add row into a table by getting the excel file dynamically.  There has been a bit on this and I wonder if it is still not possible.

 

IF create an excel file where the name of the worksheet and the table get the name from the GroupTitle.  Lets say its called "Urawa2020"  So my excel worksheet is Urawa2020.xlxs, the table is called Urawa2020.

 

I get the SP list with "get items" and use an ODATA filter for the "GroupTitle " .  

 

Then I wish to "Add a row into a table" sheet using Dynamic content like the image below

 

Odata.png

 

 

 

excel-dynamic.png

 

I get the following error.

 

 

 

{
 "error": {
 "code": "",
 "message": "The request entity's media type 'text/plain' is not supported for this resource."
 },
 "debugInfo": "clientRequestId: 73379038-6228-4daa-962a-ea11c7d42cd8"
}

 

 

Does this mean we cannot dynamically call excel files to Automate?

 

 

 

 

 

 

  • Verified answer
    v-bacao-msft Profile Picture
    on at
    Re: Dynamically get an excel file

     

    Hi @StuCundy ,

     

    Please check the limitations of Excel connector in this link:

    https://docs.microsoft.com/en-gb/connectors/excelonlinebusiness/#known-issues-and-limitations

    We should fill File’s id or File identifier in the File field if you want to configure this field manually instead of pick file from the file picker.

     

    Best Regards,

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June 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 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1