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

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

ArchitectMadhan 1,584 on at

Like (0)

Report
Copy link

Link copied!

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 at

Like (0)

Report
Copy link

Link copied!

@ArchitectMadhan My flow fails at the create table stage

Was this reply helpful? Yes No
Verified answer

Lynch66 84 on at

Like (0)

Report
Copy link

Link copied!

Update:

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

Was this reply helpful? Yes No