ClearCollect Only display "true" value.

[JB0007]

Hi Power Apps community,

I have a question about Power Automate which is a different topic than Power Apps, but maybe one of you can help me. I have created a flow for returning the corresponding value of a data inserted in a textbox in Power Apps. When I test the data, I can see all the information that is passing through the steps, which is what I wanted and it is the corresponding data. I have a button in Power Apps that I have put its Onselect as:

ClearCollect(CollectionName, PowerFlow.Run(Value(TextInput1.Text)))

When I click to see the collection, I can only see "true" in the collection. 

This is my Flow:

Can someone please help me?

[v-xida-msft · Accepted solution]

Hi @JB0007 ,

Could you please show more details about returned result about the Items variable in your Flow Run History?

Could you please share a bit more about the "Response Body JSON Schema" you specified in your Response action?

Based on the issue that you mentioned, I think there is something wrong with the "Response Body JSON Schema" value specified in your "Response" action.

The user @AnnaCICI_Z has faced similar issue with you, please check my response within the following thread:

https://powerusers.microsoft.com/t5/Building-Power-Apps/How-to-display-the-result-of-SQL-Server-on-p...

https://powerusers.microsoft.com/t5/Building-Power-Apps/Display-results-from-Flow-SQL-Stored-Procedu...

As an fixed solution, please consider take a try with the following workaround:

1. Firstly, you need to add a "Select" action below the "Filter array" action, then specify these fields you want to display in your canvas app:

2. Save your flow, then fire the flow from your Flow directly via clicking "Test" button-> "Perform the trigger action". Then go to the "Run History" of the flow run, expand the "Initialize variable" action, then copy the returned array result as below:

3. Edit your flow, go to the "Response" action, click "Generate from sample" button, then paste the previous copied array output result, then click "Done":

Response Body JSON Schema should like below:

{
    "type": "array",
    "items": {
        "type": "object",
        "properties": {
            "ProductName": {
                "type": "string"
            },
            "Department": {
                 "type": "string"
            },
            "Due Date": {
                 "type": "string"
            }
        },
        "required": [
            "ProductName",
            "Department",
            "Due Date"
        ]
    }
}

Please make sure each property under the required node should be defined with a proper data type in above properties node. If you do not specify a proper data type for each required property in the properties node, you would face "Register error" when you create a connection to your flow from your canvas app.

4. Save your flow. Then go to your canvas app editor, remove the flow connection from your canvas app, then re-create a new connection to above modified flow from your canvas app. Try the flow action again, check if the issue is solved.

Within your canvas app, execute the flow action as below:

the collection would be populated with data as below:

More details about returning table data from flow back to canvas app, please refer to the following blog:

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

Best regards,