Issue in Getting response from Power Automate to PowerApp

(0) Share

Report

Posted on by tjalui

145

Hi,

I am trying to get records of Audit History from Flow to Canvas App.

So I have created Flow, got the record in Json format and I am passing that Json data to PowerApps using Response to PowerApps.

I am able to call flow from PowerApps but not able to access collection data which came from PowerApps.

This is the json

[
 {
 "ChangedBy": "CFS Admin",
 "ChangedField": "cf_quarter",
 "ChangedOn": "25-05-2020 13:18",
 "Event": "Create",
 "NewValue": "Q3",
 "OldValue": ""
 },
 {
 "ChangedBy": "CFS Admin",
 "ChangedField": "cf_quarter",
 "ChangedOn": "25-05-2020 13:18",
 "Event": "Create",
 "NewValue": "Q3",
 "OldValue": ""
 },
 {
 "ChangedBy": "CFS Admin",
 "ChangedField": "cf_quarter",
 "ChangedOn": "25-05-2020 13:18",
 "Event": "Create",
 "NewValue": "Q3",
 "OldValue": ""
 },
 {
 "ChangedBy": "CFS Admin",
 "ChangedField": "cf_quarter",
 "ChangedOn": "25-05-2020 13:18",
 "Event": "Create",
 "NewValue": "Q3",
 "OldValue": ""
 },
 {
 "ChangedBy": "CFS Admin",
 "ChangedField": "cf_quarter",
 "ChangedOn": "25-05-2020 13:18",
 "Event": "Create",
 "NewValue": "Q3",
 "OldValue": ""
 },
 {
 "ChangedBy": "CFS Admin",
 "ChangedField": "cf_quarter",
 "ChangedOn": "25-05-2020 13:18",
 "Event": "Create",
 "NewValue": "Q3",
 "OldValue": ""
 },
 {
 "ChangedBy": "CFS Admin",
 "ChangedField": "cf_quarter",
 "ChangedOn": "25-05-2020 13:18",
 "Event": "Create",
 "NewValue": "Q3",
 "OldValue": ""
 }
]

I am collecting the response from Flow in PowerApp using this ClearCollect:

ClearCollect(
 AuditHistoryRecord,
 AuditHistory.Run(ThisItem.Objective)
);

This is collection which I am getting.

Any help is Appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (0)

Sort by

eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

Have you tried:
ClearCollect( AuditHistoryRecord, AuditHistory.Run() )
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
KrishnaV 5,023 on at

Like (0)

Report
Copy link

Link copied!

Hi @tjalui,

Change the way how you are setting the body of the Response to: body('Execute_a_SQL_query').ResultSets.Table1
Please find the below-detailed article from @briandan explaining step by step to address this issue
https://powerapps.microsoft.com/en-us/blog/return-an-array-from-flow-to-powerapps-response-method/

I hope this resolved your issue if you see any challenge let me know I am always happy to help.

Regards,
Krishna
If this post helps give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

Was this reply helpful? Yes No
v-siky-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @tjalui ,

Could you please share more details about your scenario?

What is the output of 'Run a child flow' action? Please share the run result of the flow.

Sik

Was this reply helpful? Yes No
tjalui 145 on at

Like (0)

Report
Copy link

Link copied!

The flow I am using is passing the correct json.
But in the PowerApp where I am calling the flow it is taking boolean as Datatype.

I tried adding different basic flows and returned String value and still it is showing boolean as Data Type.
I am not sure where things getting are wrong.

Was this reply helpful? Yes No
v-siky-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @tjalui ,

Please share the details about your flow and its result, and then we can help you diagnose the issue.

Sik

Was this reply helpful? Yes No
tjalui 145 on at

Like (0)

Report
Copy link

Link copied!
This is the flow which should return records of Audit History.

Run a child flow calls another flow which gets all the records of Audit History.
Then I am Parsing the Json which I get from the "Run a Child Flow" step.
I am filtering only the records and getting it into Array.
This is the Response which is Passed in PowerApp.

[ { "ChangedBy": "CFS Admin", "ChangedField": "cf_quarter", "ChangedOn": "25-05-2020 13:18", "Event": "Create", "NewValue": "Q3", "OldValue": "" }, { "ChangedBy": "CFS Admin", "ChangedField": "cf_quarter", "ChangedOn": "25-05-2020 13:18", "Event": "Create", "NewValue": "Q3", "OldValue": "" }, { "ChangedBy": "CFS Admin", "ChangedField": "cf_quarter", "ChangedOn": "25-05-2020 13:18", "Event": "Create", "NewValue": "Q3", "OldValue": "" }, { "ChangedBy": "CFS Admin", "ChangedField": "cf_quarter", "ChangedOn": "25-05-2020 13:18", "Event": "Create", "NewValue": "Q3", "OldValue": "" }, { "ChangedBy": "CFS Admin", "ChangedField": "cf_quarter", "ChangedOn": "25-05-2020 13:18", "Event": "Create", "NewValue": "Q3", "OldValue": "" }, { "ChangedBy": "CFS Admin", "ChangedField": "cf_quarter", "ChangedOn": "25-05-2020 13:18", "Event": "Create", "NewValue": "Q3", "OldValue": "" }, { "ChangedBy": "CFS Admin", "ChangedField": "cf_quarter", "ChangedOn": "25-05-2020 13:18", "Event": "Create", "NewValue": "Q3", "OldValue": "" } ]
This is the schema used in the Response.
{ "type": "array", "items": { "type": "object", "properties": { "ChangedBy": { "type": "string" }, "ChangedField": { "type": "string" }, "ChangedOn": { "type": "string" }, "Event": { "type": "string" }, "NewValue": { "type": "string" }, "OldValue": { "type": "string" } }, "required": [ "ChangedBy", "ChangedField", "ChangedOn", "Event", "NewValue", "OldValue" ] } }

Was this reply helpful? Yes No
v-siky-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @tjalui ,

Please go to Run History of the flow to show the running details of each action.

Sik

Was this reply helpful? Yes No
tjalui 145 on at

Like (0)

Report
Copy link

Link copied!

This is the Run history of the flow.

Was this reply helpful? Yes No