cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Formatting Record when using a Connector

What is the proper record format when using a connector in PowerApps? I am using the GoFileRoom connector (Document Search) action. 

The JSON body when using this action looks like this:

 

{
"DrawerId": "0000000001",
"PageNumber": 1,
"SortField": "0000000001",
"SortOrder": "ASC",
"NumberOfRows": 25,
"Filter": {
"IndexValues": [
{
"IndexId": "0000000001",
"IndexValue": "%"
}
]
}
}

 

I have tried to format in PowerApps using:

pa.png

I receive the following errors:

error.png

1 ACCEPTED SOLUTION

Accepted Solutions

Thank you sorry for posting in Power Automate instead of Power Apps community. 

 

FYI...for this post I used the following which worked.

 

Set(IndexValues,{IndexValues:Table({IndexId:"0000000001", IndexValue:"%"})});

View solution in original post

3 REPLIES 3
Frequent Visitor

 
Community Support
Community Support

Hi @calvin_leong ,

 

The error message in powerapps told that your formula is missing a column and you need to add a column to the formula.

And for powerApps issue, I suggest that you could post it in PowerApps forum so your issue could be quickly helped:

https://powerusers.microsoft.com/t5/Power-Apps-Community/ct-p/PowerApps1

 

Best Regards,

Alice

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you sorry for posting in Power Automate instead of Power Apps community. 

 

FYI...for this post I used the following which worked.

 

Set(IndexValues,{IndexValues:Table({IndexId:"0000000001", IndexValue:"%"})});

View solution in original post

Helpful resources

Announcements
New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (53,636)