Extract Json data from SharePoint List Column to create HTML and PDF

(0) Share

Report

Posted on by AdityaDani

WhatsApp Image 2022-09-16 at 12.04.27 PM.jpeg

I am using this flow to get items from a SharePoint list and send email.

One of the columns in SharePoint list contains JSON data. The Column name is Results.

WhatsApp Image 2022-09-16 at 12.22.47 PM.jpeg

When the PDF is generated the Result comes in the Json format. I want to Break it into Rows and columns.

How can I handle it.

Thanks

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Redders 546 on at

Like (1)

Report

Parse JSON action will provide you with dynamic content from the JSON.

Unless you know how to Parse JSON, you will need a sample of the JSON when using the Parse JSON so make sure you have this on hand beforehand.

Once you have Parsed the JSON, you can do what you want with the dynamic content

Was this reply helpful? Yes No
AdityaDani 54 on at

Like (0)

Report

can you direct me to a link or resource where i could learn the same?

how can i select the one column in get items to use in parse json action?

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (2)

Report

Hi @AdityaDani ,

1\Crate a new empty array variable

2\You need to iterate through the data source

In each loop

a\use JSON functions in each loop to convert the JSON string to an arrays,

b\use 'create html table' to convert the array to HTML string

c\Constructs a new Object with the values in the current loop(HTML String,items('Apply_to_each')['Age'],items('Apply_to_each')['Job title']……)

d\Append the object to the new array variable

3\Use 'create html table' to convert the array variable to HTML string

4\Note that some symbols such as '<' and '>' will be escaped and you need to convert them back using the reset function.

Best Regards,

Bof

Was this reply helpful? Yes No
Redders 546 on at

Like (0)

Report

Hi @AdityaDani,

I don't have a resource that I could direct you to I'm afraid, I have just learned by googling and trial and error.

It is fairly straightforward though, a couple of times using it and it will become second nature.

Before the Select item, add in a parse JSON, use the results from the get items in the content field.
Like I said in the previous comment, make sure you have the sample JSON from the output prior to adding the Parse JSON in and so when you click "Generate from sample", you can paste it in there
I haven't needed to parse JSON in the way that you are attempting to do it (as part of data from a get items) and so, I think it may need to be linked back in with your original data from your get items in some way. Like I said, I haven't done it before but getting the JSON in a useable format is the first issue

━━━━━━━━━━━━━━━━━━━━━━━━━
If I have answered your question, please mark your post as Solved.
Solved questions helps users in the future who may have the same issue or question quickly find a resolution via search.
If you liked my response, please consider giving it a thumbs up. Thank you!

Was this reply helpful? Yes No
AdityaDani 54 on at

Like (0)

Report

Like this?.

How should i add the parse json next ?

Was this reply helpful? Yes No