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
