Power Platform Community Forum Thread Details

Hi I am trying to retrieve a Json file from SharePoint and parse it and then do some additional transformation. But the flow is returning zero value. I don't understand why. If you look at the Parse Json, there is zero value for the output but when you click download, it does show up.

I have provided some image of the flow including the ouput, schema and code as well. Please let me know what I am doing wrong. Thank you in advance.

Categories:

Building flows

Hi , @dataYoda74

If you want to use the parse json after the "Get file content" action, you need to make the return to an array like this:

outputs('Get_file_content')?['body']

For this , you can refer to :
The property 'content' must be of type JSON in the... - Power Platform Community (microsoft.com)

And in my thought , you may do not need to use the Parse json action, if you want to get the content-type , you can use this expression:
outputs('Get_file_content')?['body']?['$content-type']

if you want to get the content , you can use this expression:

outputs('Get_file_content')?['body']?['$content']

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,

Yueyun Zhang