Power Apps

Unanswered

Keep getting error when trying to pass Power Automate response to Power Apps as a collection

(0) Share

Report

Posted on by kuraitengai

This is the output of my Power Automate response:

{

"statusCode": "200",

"schema": {

"type": "object",

"properties": {

"body": {

"type": "array",

"items": {

"type": "object",

"properties": {

"REQUESTID": {

"type": "string"

"DATEIN": {

"type": "string"

"REQ_TYPE": {

"type": "string"

"STATUS": {

"type": "string"

}

"body": [

{

"REQUESTID": "R_3aV0qW36bziUV3o",

"DATEIN": "2024-05-10T10:21:19Z",

"REQ_TYPE": "Data Summary",

"STATUS": null

{

"REQUESTID": "R_5EuzEhTorOIFrOR",

"DATEIN": "2024-05-14T09:55:31Z",

"REQ_TYPE": "Student Contact list",

"STATUS": null

}

]

}

I am trying to get that into Power Apps as a Collection.

I've used

ClearCollect(colDataReq,'PowerAppV2->Compose'.Run())

I've also tried putting in the ForAll(Table(ParseJSON('PowerAppV2->Compose'.Run().result).body)

Nothing I've tried gets the data from Power Automate into the Power Apps collection.

Any ideas for getting the data into Power Apps?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Pstork1 69,657 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

You are passing the wrong dynamic content and schema to capture it as a collection. If you want a collection then pass just the body content, which is an array. You are currently passing an object. That can't be stored in a collection, but could be stored in a variable.

Was this reply helpful? Yes No
kuraitengai 2 on at

Like
a
(0)

Report
Copy link

Link copied!

In Power Automate, I'd originally used the Response to Power Apps, selected a text input named it results and dropped the output of the compose into it. When I hit the button in Power Apps, it gave a JSON Parsing error, expected 'string' but got 'array'.

When I switched over to using Response instead, I started getting the expected 'object' but got 'array'.

I had also tried pulling in as a global variable, but that was also throwing a ContraintViolated error.

Was this reply helpful? Yes No
Pstork1 69,657 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Respond to Power Apps can't send back complex objects or arrays. You have to use HTTP Response. But when you do you have to make sure the payload and schema match how you are trying to save it in Power Apps. Collections are used to save arrays and Variables are used to save objects. Your value and schema are for an object but you are trying to save it as a collection. If you want the collection you need to adjust what you are sending to be an array.

Was this reply helpful? Yes No