Answered

Creating a table in multiple files

(0) Share

Report

Posted on by Lynch66

Following on from a previous issue (now resolved) of how to get a value from a singe cell in excel, i now need to do this to multiple files (all of which will have the same layout)

The problem i am having is that when i try to create the table in a for each loop (for each file in a folder) i am getting the following error

"BadRequest. Http request failed: the content was not a valid JSON."

Can anyone help with this

All responses (3)

Answers (1)

Verified answer

Lynch66 84 on at

Like (0)

Report

Re: Creating a table in multiple files

Update:

I have now solved this by changing "Current Item" to the "File ID" as shown below
Lynch66 84 on at

Like (0)

Report

Re: Creating a table in multiple files

@ArchitectMadhan My flow fails at the create table stage
ArchitectMadhan 1,580 on at

Like (0)

Report

Re: Creating a table in multiple files

Hi @Lynch66,
Could you please share some screen shots of JSON that you are passing. If you want to know how to add rows to a table in excel, please follow the below steps.
Excel workbook with values:

If you find my solution helpful for resolving the issue, then please consider giving thumbs up and Accept it as the solution to help the other members find it more quickly.