ClearCollect not returning fields from JSON schema Flow

Like (0) Share

Report

Posted on 5 Apr 2021 15:31:10 by Community Power Pla...

I have a Flow that is returning data from a Json schema search.Variable input.

ClearCollect(RestApi_Results,RESTAPI_INPUT_PARAMETERS_PA.Run(TextInput1.Text))

I have a Gallery on the screen to view the results.

The return from the Flow is not bring back anf fields to display.

But I have been checking the Flow and it is still running successfully. ?

response json.jpg

Thanks

Dave

Categories:

General Questions

Using Apps Using Formulas

I have the same question (0)

All responses (6)

Answers (1)

Pstork1 68,271 Most Valuable Professional on 05 Apr 2021 at 16:23:32

Like (0)

Report

Re: ClearCollect not returning fields from JSON schema Flow

Double check the Response action after a run to make sure you have a valid JSON schema for the results being returned. This is the most common problem. Another issue is if one of the required fields in the JSON schema has a record with a null value. You can use a filter array to remove those records from the results. I would also suggest using a Data Select to only send back the columns you need rather than everything returned.

Was this reply helpful? Yes No
Community Power Pla... on 05 Apr 2021 at 16:42:45

Like (0)

Report

Re: ClearCollect not returning fields from JSON schema Flow

I have never attempted this ?
"You can use a filter array to remove those records from the results"
or
I would also suggest using a Data Select to only send back the columns you need rather than everything returned.

Examples please.
dave

Was this reply helpful? Yes No
Verified answer

Pstork1 68,271 Most Valuable Professional on 05 Apr 2021 at 16:47:08

Like (0)

Report

Re: ClearCollect not returning fields from JSON schema Flow

This is from a flow that does a Get Items from a SharePoint list. the Parse JSON is there because the Select statement outputs an array, but if you need access to the individual fields you need to do a Parse JSON.

Was this reply helpful? Yes No
Community Power Pla... on 05 Apr 2021 at 19:55:43

Like (0)

Report

Re: ClearCollect not returning fields from JSON schema Flow

so lets just say, I want to bring back one fields for test right now..
"SiteName"
does this look correct ?

{
"$schema": "http://json-schema.org/draft-04/schema#",
"type": "object",
"properties": {
"ElapsedTime": {
"type": "integer"
},
"PrimaryQueryResult": {
"type": "object",
"properties": {
"CustomResults": {
"type": "array",
"items":
{ "type: "object",
"properties": {
"SiteName": {
"type": "string"
}
}
},
"QueryId": {
"type": "string"
},

The open/closed brackets syntax

Was this reply helpful? Yes No
Pstork1 68,271 Most Valuable Professional on 05 Apr 2021 at 20:59:17

Like (0)

Report

Re: ClearCollect not returning fields from JSON schema Flow

Yes, I think that's right. But the easy way to check is to put the output in a ParseJSON and see what it generates as a schema.

Was this reply helpful? Yes No
Community Power Pla... on 06 Apr 2021 at 19:22:37

Like (0)

Report

Re: ClearCollect not returning fields from JSON schema Flow

This is the perfect example and works:
https://michalguzowski.pl/search-in-sharepoint-from-powerapps/

Was this reply helpful? Yes No