You’re offline. This is a read only version of the page.
Hi everyone,
I'm trying to insert data from multiple employees from a SharePoint list into multiple Excel files, with each file named after the respective employee. However, when attempting to use a dynamic file name in the Power Automate action, I encounter an error. Could someone please help me troubleshoot this issue?
I have several Excel files, each named after an employee, containing a table named "Table1". Using Power Automate, I've retrieved the names of these employees. Now, I want to update a row in each Excel file simultaneously without having to specify each file individually.
When attempting to specify the file path in the Excel action ("/Employee Name Value.xlsx"), I encountered an error message stating "unsupported mediatype". Could someone please advise on how I can achieve this?
Thank you in advance for your assistance.
Best regards,
Ali
Have you tried replacing spaces in the file name with the text "%20"? Reason I ask is that I am wondering if it is expecting the UrlEncoded value instead of the plain text value.
Share
Report
All responses (
Answers (
488
