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

View solution in original post

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (19,285)