Answered

Creating a table in multiple files

Like (0) Share

Report

Posted on 29 Jul 2021 12:42:30 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

I have the same question (0)

All responses (3)

Answers (1)

ArchitectMadhan 1,580 on 29 Jul 2021 at 16:07:40

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.

Was this reply helpful? Yes No
Lynch66 84 on 02 Aug 2021 at 10:56:31

Like (0)

Report

Re: Creating a table in multiple files

@ArchitectMadhan My flow fails at the create table stage

Was this reply helpful? Yes No
Verified answer

Lynch66 84 on 03 Aug 2021 at 09:22:54

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

Was this reply helpful? Yes No