cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

Get Items Filter for more than one item in column

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' 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Administrator
Administrator

Quoted from @mosturl:

 

FOUND SOLUTION:

 

Status ne 'completed/closed' and status ne 'cancelled'  and Status ne 'on hold'

- Gabriel
Community Manager
Power Automate | Power Virtual Agents
Super User Program Manager
Power Platform Communities

View solution in original post

2 REPLIES 2
Community Support
Community Support

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

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Administrator
Administrator

Quoted from @mosturl:

 

FOUND SOLUTION:

 

Status ne 'completed/closed' and status ne 'cancelled'  and Status ne 'on hold'

- Gabriel
Community Manager
Power Automate | Power Virtual Agents
Super User Program Manager
Power Platform Communities

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (8,915)