cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

Filter on owner name in trigger

Writing a new flow over Dynamics Contacts, I want to filter on ownerid.  I want to not run the flow for a given owner.  How do I get the owner in a string, rather than getting the guid? 

 

Essentially, I want to trigger the flow if the owner is not "Bob".

 

Annotation 2020-06-11 142538.jpg

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Filter on owner name in trigger

 

Hi @draushaus ,

 

Please try to fill team in the right parameter of the Condition.

 

Best Regards,

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

View solution in original post

8 REPLIES 8
Highlighted
Post Prodigy
Post Prodigy

Re: Filter on owner name in trigger

Hi @draushaus ,

 

Filtering attribute : ownerid 

Filtering expression : _ownerid_value eq guid . 

 

However , this combination is not working. I would suggest you add filter condition in the next step and try doing the same like 

_ownerid_value does not equal guid 

 

Thanks

Highlighted
Community Support
Community Support

Re: Filter on owner name in trigger

 

Hi @draushaus ,

 

I am afraid that in this trigger we can only use the owner id as a filter. The Trigger body does not contain the Owner's name.

You can add Condition directly below and use the Owner name as a filter.

52.PNG

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Helper III
Helper III

Re: Filter on owner name in trigger

Thank you for the suggestion.

 

Earlier, I gave up on using a filter and resorted to using a condition, just as you show.  However, the record (a contact) is sometimes owned by a User and sometimes by a Team.  I don't know which  - and an error is returned at the 'get record'.

Highlighted
Community Support
Community Support

Re: Filter on owner name in trigger

 

Hi @draushaus ,

 

You can first check whether the owner type is teams or systemusers by using Condition.

 

If it is a team, you can get the owner's name from the Teams entity.

 

Hope that makes sense.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Helper III
Helper III

Re: Filter on owner name in trigger

That does make sense... thank you.

 

However...  the field comes up blank!

Annotation 2020-06-12 111806.jpg

 

   

 

Annotation 2020-06-12 105314.jpg

 

… though the previous "get record" step shows data in the field:

 
Highlighted
Community Support
Community Support

Re: Filter on owner name in trigger

 

Hi @draushaus ,

 

I mean you add Condition under the trigger to determine whether the Owner type of Contact is team or systemusers.

 

Owner may also be empty, which is also a factor you need to consider.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Helper III
Helper III

Re: Filter on owner name in trigger

thanks again...

 

Here's a screenshot:

 
 

Annotation 2020-06-14 214602.jpg

 

I threw the  'compose' step in so I could see why the condition was failing.  It's not pulling in the Owner Type.  When I added a 'get record' step, it shows the value of the owner(type) field as 'team':

 

Annotation 2020-06-14 214933.jpg

 

but I can't see why the Condition step can't find the value for Owner(type).

 

Highlighted
Community Support
Community Support

Re: Filter on owner name in trigger

 

Hi @draushaus ,

 

Please try to fill team in the right parameter of the Condition.

 

Best Regards,

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

View solution in original post

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (8,554)