cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
calvin_leong
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
calvin_leong
Frequent Visitor

 
v-alzhan-msft
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:"%"})});

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (1,279)