You’re offline. This is a read only version of the page.
Having some issues with the ODATA query when using "List Rows Present in the Table" to build the flow.
I have an excel file that contains a few columns and one of the columns is "Username".
I am using the "List Rows Present in the Table" to lookup this row from the excel file based on an input that comes via another source.
I need to check this using the "contains" operator but not able to figure out the correct syntax to apply in the Filter Query field.
Tried a number of different ways but they all end up in errors.
How can I get this resolved?
The error I get when running the flow is the following:
Syntax error at position 17 in 'Username contains juarestrepo'.
inner exception: Syntax error at position 17 in 'Username contains juarestrepo'.
clientRequestId: 4de78408-ae00-49ed-81aa-d70bc5e3ab38
Attached is also the screenshot of the "Get List Rows Present"
Share
Reportbody":{"status":400,"message":"Syntax error at position 17 in 'Username contains juarestrepo'.\r\n inner exception: Syntax error at position 17 in 'Username contains juarestrepo'.\r\nclientRequestId: 4de78408-ae00-49ed-81aa-d70bc5e3ab38","error":{"message":"Syntax error at position 17 in 'Username contains juarestrepo'.\r\n inner exception: Syntax error at position 17 in 'Username contains juarestrepo'."},"source":"excelonline-wus.azconn-wus.p.azurewebsites.net"}
I don't understand this.
With this code:
GroupCollectionResponse groupCollectionResponse = await GraphClient.Groups.GetAsync((requestConfiguration) =>
{
requestConfiguration.QueryParameters.Select = new string[] { "id", "displayName" };
requestConfiguration.QueryParameters.Filter = "contains(displayName, 'SLS')";
});
I get this exception:
Name Value Type
Hi @kgreen8790 thank you for that information. Is there an article or MS page that helps breakdowns all the options to filtering OData?
I ask that since I would like to learn more about the overall knowledge. My current question is can we filter by "Contains Data(Column_A)"
This should be the accepted solution.
Glad I could help
@kgreen8790 , it's okie, I just found the solution by trial and error. We can use
not contains(Description,'User_Input')
@kgreen8790 , appreciate your helpful answer. What if I want "not contains" operator?
not contains(Description,'User_Input') ?
Here's the proper format for contains in Odata filter query: contains(Column_A, 'text to filter')
See screenshot for additional info.
Be sure to mark my response as "solution" if this has solved your issue.
@Shuvam-rpa I will try your suggestion and that might work, will post the result here.
I am concerned about the size of data loaded as overtime this file will grow significantly in size so loading all rows and then filtering will this lead to any issue due to number of records?
@sachinmishra If the above reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
@sachinmishra I would recommend you to leave odata filter blank in list rows present in a table action and then after it create filter array action where you can filter the record using contains . please check below screenshot as reference
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
#1
stampcoin
23
#2
Pstork1
20
Most Valuable Professional
#3
Gprior
19
All responses (
Answers (