Unanswered

Sharepoint and excel combo flow fails

(0) Share

Report

Posted on by Community Power Pla...

I have build a flow when uses got items and get rows actions to compare the field and then import into SharePoint. The problem that i got was that a filed has a fulls-stop and it is must to accept within the flow.

Error:

{

"status": 400,

"message": "Syntax error at position 14 in 'Client Account Name eq 'Al Clawson Disposal Inc.''.\r\n inner exception: Syntax error at position 14 in 'Client Account Name eq 'Al Clawson Disposal Inc.''.\r\nclientRequestId: e59aa55e-b563-4845-8475-78a418d26539",

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

}

Categories:

Using connectors

I have the same question (0)

All responses (5)

Answers (1)

efialttes 14,756 on at

Like (0)

Report

@Anonymous

You are using ODATA filter query, right?

If so, this thread can be useful, it discuss the a similar problem with the & character, both in the context of ODATA filter queries and its most common alternative: Filter Array approach, less efficient, but sometimes more powerful

Hope this helps

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

thank you, where can i get the complete list of conversions for all the special characters? The thread has very less info and mine is not about the same.

Was this reply helpful? Yes No
efialttes 14,756 on at

Like (0)

Report

@Anonymous

Unfortunatelly I do not have an exhaustive special characters ODATA conversion list, but...

let's see if this other thread is useful.

The recommendation in such scenarios is to use Get items directly to get the contents of the Body, observe what the Column name is displayed there, and then configure it in the Filter query input.

Hope this helps

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft on at

Like (0)

Report
Hi @Anonymous ,

Since your Column name contains space, when Odata is queried, the name it displays is not the original name.

I have made a test on my side to create a Client Account Name field in the list, when use Odata filter, the expression should as below:

ClientAccountName eq 'Al Clawson Disposal Inc'

For easy solution, you could use the filter array action as screenshot below:

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
Community Power Pla... on at

Like (0)

Report

@v-alzhan-msft thank you alice. I have more than 500 rows of such cases. How exactly can i app;ly the filter? Not evry field has a fullstop. but i am really stuck here.

Was this reply helpful? Yes No