Error replacing Excel File and parsing json into it

[AndreasK96]

Hi all, 

im new to Power Automate and currently try to create a flow where a json is first initialized in a variable (array). I use parse json to create a schema and afterwards want to pass the values into an excel file one by one. After that the file should be copied into a different location and renamed. The original file should be returned to its original blank state by replacing the file from a different folder so that the flow can start again. 

This flow works exactly once because the second time the flow outputs an error which tells me it cant find the table anymore.

Does anyone has an idea how to solve this issue ? 

[Nived_Nambiar]

Hi @AndreasK96 

Just want to check whether the new excel file has table inside it.

Also you can try something simmilar as well to resolve this issue

Expression used- 

first(outputs('Get_tables')?['body/value'])?['id']

So first the flow gets list of tables present in excel file and then in second action, it will take take the first table out of it (assuming it has one table) using its id in list rows in table action.

Thanks & Regards,

Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

[AndreasK96]

Hi Nived, 

thank you for your reply. I should have provided more detailed information. My bad.. 

I have a file on my OneDrive called "meetingTemplate.xlsx" From a Canvas App I receive a JSON which I parse through this meetingTemplate. Until here everything works. 

Now I want to move this meetingTemplate File to a different folder and rename it. The last step should be that a blank meetingTemplate file should overwrite the "used" template file and therefore once the flow starts again a clean file will be used. 

This, as of right now doesn't work because once this happens I receive the error you can see in the picture. Perhaps there is a better solution to this ? If, so happy to get some feedback to this. I don't expect any free solutions, but some guidance would be helpful.

What I want to achieve

A JSON String, which I receive from Power Apps should be parsed into an excel file and renamed according to the users input. After this is finished the meetingTemplate should be replaced by the blank one and be ready to be used for the next flow. Please see the picture below to see how the excel should look like :

[Nived_Nambiar]

Hi @AndreasK96 

I got it, but need one more confirmation, does the meetingtemplate which u are overwriting does it have empty table with now rows ?

Also did you tried the approach whichi have suggested ?

Thanks & Regards,

Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

[AndreasK96]

Hi @Nived_Nambiar,

the blank meetingTemplate only has an empty Table inside it. I will try to use your solution during the day and get back to you. 

Thank you so far !

Thanks & Best Regards

Andreas

[AndreasK96]

Hi again Nived, 

i´ve been trying to apply your solution but im sort of unsure what value now to put inside here

I´ve been applying your solution into the flow right before this one here. 

Thank you for your help so far. 

Best Regards

Andreas

[Nived_Nambiar]

Hi @AndreasK96 

You have missed Get tables action 

see my first response. You will get details there 🙂

Thanks & Regards,

Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

[Nived_Nambiar]

Hi @AndreasK96 

You have missed Get tables action 

see my first response. You will get details there 🙂

Thanks & Regards,

Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌