Unanswered

Returning list of files to PowerApps

(1) Share

Report

Posted on by NCF35

Hi,

I am quite new to PowerApps, have read many forums on how to return JSON back to PowerApps
However, when trying to use Power Automate to get the file contents of a folder in SharePoint and then returning back to PowerApps to be displayed in gallery the contents. However, when i put

Set(response, Test.Run());

It gives the error:

Error.(JSON parsing error, expected 'object' but got 'array'

I've double checked the schema and everything seems correct, anyone knows why its not working?

I have attached the image of the flow.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

anandm08 1,936 Super User 2024 Season 2 on at

Like (1)

Report
Copy link

Link copied!

hi @NCF35 ,
in the response body schema, the type is an object that's why you are getting the object back not array one more thing you should use collect function to store array response

Was this reply helpful? Yes No
NCF35 6 on at

Like (1)

Report
Copy link

Link copied!

Hi @anandm08 ,
I tried ClearColllect and Collect based on your suggestion, still same error.

Was this reply helpful? Yes No
anandm08 1,936 Super User 2024 Season 2 on at

Like (1)

Report
Copy link

Link copied!

have you changed the 1st that is type of schema to array if not try to generate from a sample that I have marked in 2nd in my screenshort.

Was this reply helpful? Yes No
NCF35 6 on at

Like (1)

Report
Copy link

Link copied!

Hi @anandm08,
Unfortunately, that didnt solve my issue either
Sample of Body(contents censored):
{
"Name": "xxxxx.pdf",
"Path": "/Shared Documents/xxxx/xxxxx.pdf",
"IsFolder": false
}

Heres the json schema:
{
"type": "object",
"properties": {
"Name": {
"type": "string"
},
"Path": {
"type": "string"
},
"IsFolder": {
"type": "boolean"
}
}
}

I also tried a method where you add [] to have certain fields required:
Json Schema Generated:
{
"type": "array",
"items": {
"type": "object",
"properties": {
"Name": {
"type": "string"
},
"Path": {
"type": "string"
},
"IsFolder": {
"type": "boolean"
}
},
"required": [
"Name",
"Path",
"IsFolder"
]
}
}

I tried both of this with ClearCollect, Collect, and also Set, all not working unfortunately.
I also tried changing the thing from "object" to "array" still same issue.
still
Error.(JSON parsing error, expected 'object' but got 'array'
Is there any other reason this could be happening?

Was this reply helpful? Yes No