You’re offline. This is a read only version of the page.
Hi Community,
I have been working on a flow to dynamically convert a range in excel to a table format. I have found a way to do it manually using an office script (Figure 01) and a power automate flow triggered manually (Figure 02)
Figure 01.
Figure 02
This flow works perfectly when triggered manually. However, I would like to make this dynamic to avoid indicating each time the excel file (red circle in figure 02).
My first try was then to use the flow below (figure 03):
Figure 03
However, I got an error (figure 04)
Figure 04
I suppose I have to get the content of the file for it to work better so I did a second try (figure 05)
Figure 05
This did not work either (figure 06) and is actually creating a lot of files without stopping 😅 had to turn it off.
Figure 06
Do you know any simple way to make my flow from the beggining of this message work with an automated trigger like "when a file is created or modified" instead of the manual trigger? This in order to make the flow dynamically considered each new file
Thanks,
Julian
@rzaneti ,
Thank you for your prompt reply. Unfortunately it did not work for me (image below) 😞 Still the same error.
I did as you suggested: adding "get file properties", using "ID" from "When a file is created. Then, using "full path" from the "Get file properties" in the "Run Script" space dedicated to file.
Hi @Julianveda ,
I've jus tried to replicate the same flow as you have, and got the same error. After some tests, I found that you need to add a "Get file properties" action before the "Run Script", pass the created file ID to it, and then use the "Full path" dynamic content from this Get file properties into Run Script file path.
I don't have details about why do we need to include this additional step, but it worked fine for me!
Let me know if it works for you or if you need any additional help!
-------------------------------------------------------------------------
If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.
http://digitalmill.net/
https://www.linkedin.com/in/raphael-haus-zaneti/
Hi @rzaneti ,
Thank you for your answer. I gave a try to your recommendation (figure 01). However, I get another error (figure 02). Am I doing something wrong?
Figure 01
Figure 02
Julian
Hi @Julianveda ,
You are referencing the file ID, while you should be using the file path as input. This small change in the input must solve the problem:
Let me know if it works for you or if you need any additional help!
-------------------------------------------------------------------------
If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.
http://digitalmill.net/
https://www.linkedin.com/in/raphael-haus-zaneti/
#1
WarrenBelz
146,660
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,004
Most Valuable Professional
Share
Report
All responses (
Answers (
