Return data to Power Apps with Power Automate and display the results in the app

(0) Share

Report

Posted on by ConsultantIT

110

Hello everyone,

I tried this solution explained in this post: https://powerautomate.microsoft.com/en-us/blog/return-data-to-powerapps/

I have a power app that send a request to an other system thanks to Power automate, and then I return these results to my app.

My issue is that this solution doesn't work in my app: I tried to return my results as Text but this Split function still doesn't work => by the way, I am not sure this is the best option.

I can return multiple records to my app. I would like to display them as a gallery for example, in order to show them like an array.

How can I handle that?

My results can be managed as an array in Power automate, and then my results are displayed this way in my app:

Or I can also display the results this way:

I want to display them like that:

S0000099 Vendor1

S0000001 Vendor 1

Once this array will be created, I will want to click on one of the records and display more information about it.

Can you give me some help on this?

Thanks a lot

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

PowerRanger 3,458 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Frog64 How does the output of "respond to Powerapp or flow" looks like. Take a Look at your flow runs and check the Action. Could you post the result here.

Was this reply helpful? Yes No
ConsultantIT 110 on at

Like (0)

Report
Copy link

Link copied!

I tried two different options, here are the results:
If the Output is an array:
{
    "statusCode": "200",
    "schema": {
        "type": "object",
        "properties": {
            "valeurs": {
                "title": "valeurs",
                "x-ms-dynamically-added": true,
                "type": "string"
            }
        }
    },
    "body": {
        "valeurs": "[{\"Account\":\"S000099\",\"Name\":\"Vendor1\"},{\"Account\":\"S00000001\",\"Name\":\"Vendor1\"}]"
    }
}

Or if it is a string:
{
    "statusCode": "200",
    "schema": {
        "type": "object",
        "properties": {
            "valeurs": {
                "title": "valeurs",
                "x-ms-dynamically-added": true,
                "type": "string"
            }
        }
    },
    "body": {
        "valeurs": "S000099,Vendor1\nS00000001,Vendor1\n"
    }
}

But maybe do I need something else?

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

Like (0)

Report
Copy link

Link copied!

Hi @Frog64 :

Do you want to pass the array in the flow to the APP in table format? If so, please try the response action.

I think this link will help you a lot:
Walkthrough: Use Flow in PowerApps to upload files or return data tables

You can also refer to the thread I have participated in before:
Power Canvas Application - Power Platform Community (microsoft.com)

Best Regards,

Bof

Was this reply helpful? Yes No