You’re offline. This is a read only version of the page.
2
Hi All,
I have excel column name is Department and the values is multiple for eg:(IT,Computer Science Engineering,EEE,Data Science)
I need to select only Computer Science and Data Science in the department column. I'm not able to use the filter query in list rows action since its excel we would be able to filter 1 value so i used the filter array
@And(equals(item()?['Department'],'Computer Science'),equals(item()?['Department'],'Data Science'))
this will shows me the result is empty array [ ]. I tried running this as separate and i'm able to get the value. If i want to select both values for 1 column how to do this please help me.
Thanks.
Hi @Priyanka03
Pls try the below expression to get the desired filter result. The idea is check if the sub string exists in the column value:
@and(greater(indexOf(item()?['Department'], 'Data Science'), 0),greater(indexOf(item()?['Department'], 'Computer Science'), 0))
If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.
Thanks
Share
Report
All responses (
Answers (
