web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Automate
Answered

Get table Dynamically

(0) ShareShare
ReportReport
Posted on by 2

Hey,

 

I have a flow currently set up to take in an email with an attatched excel (set template). Then i have it going into onedrive (business), however when i try to read all the rows (either rows or table can work with either) i cannot set the file to be the result of the new file in onedrive.

Please note* Once i have the rows i am going to itterate through them and query them into my database

refer to images below.

1.PNG2.PNG

The first image works however the second does not providing the following error:

{
"status": 400,
"message": "The parameter 'file' has an invalid value '/Digital Marketers/01_07_2019 - Fun Marketer Name - Digital Marketing Invoice.xlsx'."
}
which doesnt make sense to me as the "invalid value" is identical to the hardcoded string.
 
Thanks,
Categories:
I have the same question (0)
  • Verified answer
    yashag2255 Profile Picture
    24,769 Super User 2024 Season 1 on at

    Hi @WebDev 

     

    This is a known issue with the Excel connector. You cannot provide a variable name or a dyanmic name to an excel file or the excel table. You have to select the excel file by clicking on the folder icon and choosing the file and then selecting the table from the drop down. You cannot pass a path/ variable name to get the list of rows etc. from the excel connector. 

     

    Hope this Helps!

     

    If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

  • Sidkn33 Profile Picture
    30 on at

    Hello,

    I am trying to do something similar - Flow to create a an excel file from an existing file with a (blank) table in it, and in the same Flow, populate the new file/table dynamically.Flow refer dynamically to file table created in same flow.png
    Is there any way to achieve something like this?

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 112 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 52

#3
Ellis Karim Profile Picture

Ellis Karim 51 Super User 2026 Season 1

Last 30 days Overall leaderboard