Parsing JSON in Power Automate

(0) Share

Report

Posted on by oappdev

901

Happy Friday,

l 'm struggling on this one a lot. l 'm able to pass a JSON collection to Power Automate just fine. The Parse JSON output is not displaying the Value. What l 'm doing wrong?

Please let me know if you any additional information about the flow. As always thank you so much in advance.

Categories:

Building flows

I have the same question (0)

All responses (10)

Answers (2)

MJain 2,450 on at

Like (0)

Report

Hi @oappdev ,

What are your expectations from this output. I do not see what is missing from the output.

Thanks

Was this reply helpful? Yes No
oappdev 901 on at

Like (0)

Report

Thank you so much @ManishJain for the quick response. My apologize, Still learning JSON and Power Automate.
Here is my flow steps by steps, please let me know if this helps.

Expectations will be when the user select the generate button in PowerApp , it will Autofill the PDF form with the value.

The full flow

l'm i doing this wrong or missing an extra step? Thank you again.

Was this reply helpful? Yes No
oappdev 901 on at

Like (0)

Report

As you could see it work when i hard coded it. Hope this helps.

Was this reply helpful? Yes No
MJain 2,450 on at

Like (0)

Report

HI @oappdev ,

Thanks for detailed description of flow. Are you using Parse JSON step on output of Get File Content.

Thanks

Was this reply helpful? Yes No
oappdev 901 on at

Like (0)

Report
You're very welcome. @ManishJain I would like to say - Yes.

Here is the Parse JSON output. let me know if this helps.

{ "body": { "Provider NameRow1": "", "National Provider Identifier NPIRow1": "", "Date of Service MMDDYYYY One date per rosterRow1": "", "Medicare IDRow1": "", "Date of Birth MMDDYYYYRow1": "", "Patient Signature or Signature on fileRow1": "", "Last NameRow1": "", "First NameRow1": "", "MIRow1": "", "Sex MFRow1": "", "Address No StreetRow1": "", "CityRow1": "", "StateRow1": "", "ZipRow1": "", "Medicare IDRow1_2": "", "Date of Birth MMDDYYYYRow1_2": "", "Patient Signature or Signature on fileRow1_2": "", "Last NameRow1_2": "", "First NameRow1_2": "", "MIRow1_2": "", "Sex MFRow1_2": "", "Address No StreetRow1_2": "", "CityRow1_2": "", "StateRow1_2": "", "ZipRow1_2": "", "Medicare IDRow1_3": "", "Date of Birth MMDDYYYYRow1_3": "", "Patient Signature or Signature on fileRow1_3": "", "Last NameRow1_3": "", "First NameRow1_3": "", "MIRow1_3": "", "Sex MFRow1_3": "", "Address No StreetRow1_3": "", "CityRow1_3": "", "StateRow1_3": "", "ZipRow1_3": "", "Medicare IDRow1_4": "", "Date of Birth MMDDYYYYRow1_4": "", "Patient Signature or Signature on fileRow1_4": "", "Last NameRow1_4": "", "First NameRow1_4": "", "MIRow1_4": "", "Sex MFRow1_4": "", "Address No StreetRow1_4": "", "CityRow1_4": "", "StateRow1_4": "", "ZipRow1_4": "", "Medicare IDRow1_5": "", "Date of Birth MMDDYYYYRow1_5": "", "Patient Signature or Signature on fileRow1_5": "", "Last NameRow1_5": "", "First NameRow1_5": "", "MIRow1_5": "", "Sex MFRow1_5": "", "Address No StreetRow1_5": "", "CityRow1_5": "", "StateRow1_5": "", "ZipRow1_5": "", "Reset Form": "", "Print Form": "" } }

Was this reply helpful? Yes No
Verified answer

MJain 2,450 on at

Like (0)

Report

Thanks again. I see that output from file content is getting all fields empty , it is not the issue with Parse JSON but your output of file content. Can you please check if there is data available for your input.

Thanks

Was this reply helpful? Yes No
oappdev 901 on at

Like (0)

Report

You're very welcome @ManishJain What is interested that there is data from my input. Also when i run a test, the flow is able to read my the file content. l know l'm missing something.🤔

The file content

As always thank you.

Was this reply helpful? Yes No
oappdev 901 on at

Like (0)

Report

Hi @ManishJain I was able to get Parse JSON to get Content, It look like i have to fix the Schema. Do you have an example? How can i convert it over to an Object?

Thank you for your help!

Was this reply helpful? Yes No
Verified answer

AndreyBear 42 on at

Like (0)

Report

The problem is - you are passing that json wrapped into a list. See that last "]" in the input content? Take it out of the list and try again.

Was this reply helpful? Yes No
oappdev 901 on at

Like (0)

Report

Thank you both @ManishJain @AndreyBear With your advice, I finally got the flow to work. 😁

Was this reply helpful? Yes No