Answered

Formatting Record when using a Connector

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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:

I receive the following errors:

Categories:

Using connectors

I have the same question (0)

All responses (3)

Answers (1)

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
v-alzhan-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No