cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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
Anonymous
Not applicable

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
Anonymous
Not applicable

 
v-alzhan-msft
Community Support
Community Support

Hi @Anonymous ,

 

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.

Anonymous
Not applicable

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
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (3,812)