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

Notifications

Announcements

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 525 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 324 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard