Power Platform Community Forum Thread Details

I'm customizing a SP list using PowerApps and running into an error which I can't seem to resolve.

I have a drop down field which is pulling in Items from an excel table (Table1) based on a Filter formula.

Items: Filter(Table1, Group = DataCardValue10.Selected.Value)

Value: Request Type

Default: Parent.Default

Card Default: ThisItem.'Request Type'

Update: DataCardValue11.Selected.'Request Type'

Basically the filter is looking at the Group column in Table1 and the Group field (datacardvalue10) to bring in all "Request Types" associated with that Group. The Request Types are also stored in Table1. Currently this setup is producing the error noted in the Subject line which also prevents these fields from saving to the SharePoint list upon submitting via a patch function.

Has anyone ran into this issue? Is there a solution?

Categories:

Building Power Apps

I'm running into this same exact issue when trying to filter a drop down based on the result of another ComboBox. The dataset is an excel file table with <2000 rows. Any help would be much appreciated.

Sheet name in excel is Salesperson.

Combobox (named: UpdatedSP1) Items value is : Distinct(Salesperson,'Salesperson Name')

Dropdown Items value is : Filter(Salesperson, 'Salesperson Name' = UpdatedSP1.Selected.Result)

The errror I'm getting in the Monitor:

{

"duration": 110.6,

"size": 526,

"status": 400,

"headers": {

"Cache-Control": "no-cache,no-store",

"Content-Length": 526,

"Content-Type": "application/json",

"Date": "Fri, 09 Dec 2022 21:07:22 GMT",

"expires": -1,

"pragma": "no-cache",

"strict-transport-security": "max-age=31536000; includeSubDomains",

"timing-allow-origin": "*",

"x-content-type-options": "nosniff",

"x-frame-options": "DENY",

"x-ms-apihub-cached-response": true,

"x-ms-apihub-obo": true,

"x-ms-request-id": "43069421-f067-41b0-a9f3-7624d54233e2",

"x-ms-user-agent": "PowerApps/3.22111.28 (Web AuthoringTool; AppName=a23fddb5-eafb-472b-8abc-46fa08a4fd58)",

"x-ms-client-request-id": "43069421-f067-41b0-a9f3-7624d54233e2"

"body": {

"status": 400,

"message": "Syntax error at position 16 in 'Salesperson Name eq 'COLE MATTHEWS''.\r\n inner exception: Syntax error at position 16 in 'Salesperson Name eq 'COLE MATTHEWS''.\r\nclientRequestId: 43069421-f067-41b0-a9f3-7624d54233e2",

"error": {

"message": "Syntax error at position 16 in 'Salesperson Name eq 'COLE MATTHEWS''.\r\n inner exception: Syntax error at position 16 in 'Salesperson Name eq 'COLE MATTHEWS''."

"source": "excelonline-wus.azconn-wus.p.azurewebsites.net"

"responseType": "text"

}