cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Power Apps views Power Automate Array as boolean.

I've been away from Power Apps for a couple months, and evidently things have changed.  I'm calling a Power Automate Flow, that executes a SQL Query and returns an array.  The Flow works as expected, and the response returns the array in the body.  When I set this value to a collection in Power Apps, it only shows one column with "Value" set to "true".  How do I get it to honor the schema sent back in the response?

Steveo1_0-1613176311888.png

 

 

 

ClearCollect(
    FilteredRecords,
    AADtoFOGetGiftsByBatchType.Run(
        Text(
            DatePickerStart.SelectedDate,
            "yyyy-mm-dd"
        ),
        Text(
            DatePickerEnd.SelectedDate,
            "yyyy-mm-dd"
        ),
        JSON(
            ThisItem.Value.BatchPrefixes
        )
    )
);

 

 

 

Steveo1_1-1613176595233.png

 

 

  

 

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

I solved this.  For anyone else who encounters this issue, an experimental feature (under advanced settings) that used to be on by default was turned off.  I had to turn it on, close the app, and refresh the browser for it to work

Steveo1_0-1613226959803.png

 

View solution in original post

4 REPLIES 4
gabibalaban
Super User
Super User

Hi @Anonymous ,

Talking in standard connectors ...

There is nothing wrong and nothing changed in PoweraApps regarding your issue. The PowerAutomate does not return and never returned array as response to PowerApps.

Here are the options:

 
 

In your PowerAutomate flow you need to define the parameter which will be returned to PowerApps and inside PowerApps you can refer to this parameter as:

Set(myReturnedParameter, YouFlow().myDefinedParameterInPowerAutomate)

 

The value you received and you kept in a collection is the confirmation that the flow run successfull.

 

Hope it helps !

Anonymous
Not applicable

@gabibalaban , Thanks for your reply.  I'm not talking about the "Respond to PowerApps" action.  I'm aware it does not return an array.  I am talking about what Microsoft refers to as the "response method".  Return an Array from Flow to PowerApps (Response Method) | Microsoft Power Apps.  This blog post is from 2018, but I have done this in other Power Apps to successfully return arrays, as recently as a few months ago.  

Anonymous
Not applicable

Here is an example of a document security Power App I worked on a few months ago.  It gets categories from a SharePoint list (and security roles from SharePoint), to determine which file categories a user can view.  It is still successfully returning an array to Power Apps.  

Steveo1_2-1613222805703.png

Steveo1_3-1613222827220.png

 

 

Anonymous
Not applicable

I solved this.  For anyone else who encounters this issue, an experimental feature (under advanced settings) that used to be on by default was turned off.  I had to turn it on, close the app, and refresh the browser for it to work

Steveo1_0-1613226959803.png

 

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (3,910)