My flow is triggered based on a form being submitted.
The aim of the flow is to match the ReqID and email against an existing Excel sheet and return the unique row which is then added to another excel.
I'm using the following ODATA query to filter:
Email eq 'dynamicemailaddressfromform' and ReqID eq 'dynmaicReqIDfromform'
The error I get is as follows:
'Invalid filter clause: unsupported operation. Only single 'eq', 'ne', 'contains', 'startswith' or 'endswith' is currently supported'
Does this mean that even though 'and' is supported by ODATA, I can only use a single 'eq' for the excel connector?
If so, is there a workaround for this i.e. to identify the unique row using a combination of ReqID and Email?
Thanks in advance!
Hi @Ash_R ,
Yes you can use only single 'eq', 'ne', 'contains', 'startswith' or 'endswith' .
This is how i would achieve:
use only one Odata eq expression in your "List Row Present in Table"
than i will use "Filter Array" action on the "List Row Present in Table" results to filter with second condition.
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Hi @Ash_R ,
When configuring Filter Query in List rows present in a table action, we can only configure a single filter, and temporarily do not support using “and” to configure multiple filters.
Please check this idea and vote for it:
Also as @DeepakS described, Filter array is a good choice, please take a try and feel free to let us know if you have any other questions.
With Filter Array, I couldn't figure out a way to get the info into an excel file for further analysis.
I was able to create an HTML table but struggled to get this back into Excel.
So here's what I did instead:
In my source data (excel), I created a new blank table. This had the same column names and formatting as the original table.
In the flow
Will post a screenshot as well!
Hi @Ash_R ,
You can use the Parse JSON action to parse the body of the Filter array, and then insert the dynamic content of the Parse JSON output into a new Excel table.
Check out the new Process Advisor community forum board!
Check out new user group experience and if you are a leader please create your group
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.