Convert an Excel range to an Excel table with an automated trigger

[Julianveda]

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]

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/ 

[Julianveda]

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

[rzaneti]

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/ 

[Julianveda]

@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.