Answered

Powerautomate Sharepoint to fill PDF flow JSON error

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello!

I am attempting to do a flow that pulls from "Lists" in sharepoint. You will see below that it will only pull information when a certain field is filled in the list (that is what the condition is for). "Get the file content" is to get the PDF template that needs to be filled which then routes to "Fill in PDF Form" thorugh Plumsail. Under that step, it requests the JSON in which I have input dynamic content from the sharepoint List. Whenever I run a test, it fails on the "Fill in PDF Form" step saying: "The value should be a valid JSON object or array". I have used this same JSON to do a PDF fill from a Microsoft form with no issue but it is not working from this, am I missing something that should be done for this to work?

Here is the entire flow:

This is the JSON information under "Fill in PDF Form":

And here is the error that I am receiving when I run a test:

Any help would be greatly appreciated! Thank you!

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

eric-cheng 5,171 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

I usually use something like this to verify my JSON schema.

Also, check if there are any special characters in your values which may need to be escaped? You can have a look here.

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I did verify the JSON and it is valid according to that website you shared, I looked for special characters but I'm not sure what to look for exactly. I tried putting the forward slash in front of each quotation mark but it still did not work and came out with the same error.
I also now adjusted it so the condition is in the trigger itself and everything is out of the condition now, just FYI

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I figured out my issue, some of the referenced sharepoints in the JSON were to a contact which were too big for the field in the PDF to handle, thank you for your help!

Was this reply helpful? Yes No