I am looking for a way to pull in more than one column value in a get items request in Flow. My "Status" column contains values: plan and initiative, design, build and test, implement, monitor, completed/closed, cancelled and on hold. I'm trying to pull in only those not equal to completed/closed, cancelled and on hold.
FOUND SOLUTION:
Status ne 'completed/closed' and status ne 'cancelled' and Status ne 'on hold'
Solved! Go to Solution.
Quoted from @mosturl:
FOUND SOLUTION:
Status ne 'completed/closed' and status ne 'cancelled' and Status ne 'on hold'
Hi @mosturl,
Thanks for sharing and updating.
More details about Odata filter query, please check the doc at here:
https://docs.microsoft.com/en-us/previous-versions/dynamicsnav-2016/hh169248(v=nav.90)
Best regards,
Mabel Mao
Quoted from @mosturl:
FOUND SOLUTION:
Status ne 'completed/closed' and status ne 'cancelled' and Status ne 'on hold'
User | Count |
---|---|
38 | |
35 | |
15 | |
13 | |
12 |
User | Count |
---|---|
23 | |
20 | |
18 | |
13 | |
13 |