Help) Power Apps with Power Automate

(0) Share

Report

Posted on by Community Power Pla...

I created a power app to call the power automate.

Scenario)

1) Click 'Search' Button on Power Apps

Collect(RENVendor, GetVendorListByNameNoRange.Run())

2) Call Power Automate and Return responce

Power Automatic's run history is a success.

But, There is no data in the Collect named RENVendor.

responce JSON Schema

{

"type": "array",

"items": {

"type": "object",

"properties": {

"ItemInternalId": {

"type": "string"

"dataAreaId": {

"type": "string"

"AccountNum": {

"type": "string"

"NameAlias": {

"type": "string"

"Name": {

"type": "string"

"LanguageId": {

"type": "string"

"@odata.etag": {

"type": "string"

}

"required": [

"@odata.etag",

"ItemInternalId",

"dataAreaId",

"AccountNum",

"NameAlias",

"Name",

"LanguageId"

]

}

All responses (6)

Answers (1)

Community Power Pla... on at

Like (0)

Report

Re: Help) Power Apps with Power Automate

I modified the power automate.
I have added a 'Select' before the 'Response' from the power automation.
I've checked the power apps to make sure the data is coming out right.
The data is properly visible in the power app.

my flow
Power Apps -> D365SCM connector -> Select -> 'Response'
Community Power Pla... on at

Like (0)

Report

Re: Help) Power Apps with Power Automate

The operation was successfully completed even when we checked with power app monitoring.
Community Power Pla... on at

Like (0)

Report

Re: Help) Power Apps with Power Automate

Attached is the configuration and execution result of the flow I created.

respoone schema

{
    "type": "object",
    "properties": {
        "body": {
            "type": "object",
            "properties": {
                "@@odata.etag": {
                    "type": "string"
                },
                "ItemInternalId": {
                    "type": "string"
                },
                "dataAreaId": {
                    "type": "string"
                },
                "AccountNum": {
                    "type": "string"
                },
                "NameAlias": {
                    "type": "string"
                },
                "Name": {
                    "type": "string"
                },
                "LanguageId": {
                    "type": "string"
                }
            }
        }
    }
}
v-yutliu-msft on at

Like (0)

Report

Re: Help) Power Apps with Power Automate

Hi @Anonymous ,

Do you mean that you will get an empty result in powerapps from the response of flow?

I think the problem should be about your flow's configuration.

Could you show me more details about your flow's configuration?

Especially the response part.

Here are two similar issues for your reference:

https://powerusers.microsoft.com/t5/Building-Power-Apps/Returning-Array-via-Response-Blank-Array/td-p/175389

https://powerusers.microsoft.com/t5/Building-Power-Apps/Issue-executing-a-SQL-SP-with-a-response-to-PoweApps-from-Flow/m-p/173352#M57846

Here's a blog about "Return an Array from Flow to PowerApps" for your reference:

https://powerapps.microsoft.com/en-us/blog/return-an-array-from-flow-to-powerapps-response-method/

What's more, could you translate your language of your flow's configurations to English if you are convenient?

Sorry I' m not familiar with Korean.

Best regards,
Community Power Pla... on at

Like (0)

Report

Re: Help) Power Apps with Power Automate

Thank you.

After checking the power app monitoring, it receive the following responses.
I don't quite understand the following phrase. Can you give me more details?
"try inserting a select before the response and map only specific properties,"

{
"duration": 1628.58,
"size": 58045,
"status": 200,
"headers": {
    "Cache-Control": "no-cache",
    "content-encoding": "gzip",
    "Content-Type": "application/json; charset=utf-8",
    "Date": "Tue, 31 Mar 2020 00:50:34 GMT",
    "expires": -1,
    "pragma": "no-cache",
    "strict-transport-security": "max-age=31536000; includeSubDomains",
    "timing-allow-origin": "*",
    "vary": "Accept-Encoding",
    "x-ms-apihub-cached-response": true,
    "x-ms-client-tracking-id": "08586159910519798959205356628CU24",
    "x-ms-correlation-id": "fb42ce4b-7439-4533-b02f-0f8e1e7a51dc",
    "x-ms-execution-location": "southeastasia",
    "x-ms-ratelimit-burst-remaining-workflow-writes": 14999,
    "x-ms-ratelimit-remaining-workflow-download-contentsize": 1073683779,
    "x-ms-ratelimit-time-remaining-directapirequests": 99999084,
    "x-ms-request-id": "southeastasia:fb42ce4b-7439-4533-b02f-0f8e1e7a51dc",
    "x-ms-tracking-id": "fb42ce4b-7439-4533-b02f-0f8e1e7a51dc",
    "x-ms-trigger-history-name": "08586159910519798959205356628CU24",
    "x-ms-workflow-id": "9c00c3d3039e473d8df9da3eaaa552b1",
    "x-ms-workflow-name": "d450e547-83c1-476e-855e-334c8af4fd75",
    "x-ms-workflow-run-id": "08586159910519798959205356628CU24",
    "x-ms-workflow-system-id": "/locations/southeastasia/scaleunits/prod-02/workflows/9c00c3d3039e473d8df9da3eaaa552b1",
    "x-ms-workflow-version": "08586160555562004112"
},
"body": [
    {
      "@odata.etag": "W/\"JzE2NTE1NjEyMiw1NjM3MTQ0NTc2Jw==\"",
      "ItemInternalId": "1db1d697-16db-48c1-a963-2297a22aa469",
      "dataAreaId": "yhc",
      "AccountNum": "V000001",
      "NameAlias": "연희화학(주)",
      "Name": "연희화학(주)",
      "LanguageId": "Ko-kr"
    },
    {

.
.
.
.
.
}
Verified answer

RajYRaman 270 on at

Like (1)

Report

Re: Help) Power Apps with Power Automate

@Anonymous- This usually happens if there is something wrong with schema vs what data is being returned. Did you make any changes to the Flow, after adding it to the canvas app? If so, try removing the Flow and re-adding it. You can also run Power Apps Monitor on you canvas app, and confirm that the response is coming through from Flow properly.

Just to confirm that the schema to data mapping is correct, try inserting a select before the response and map only specific properties, and returning the select on the response, with the correct schema, rather than dumping the raw response.