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
MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

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

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (36,099)