cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tissanfr
Frequent Visitor

How to get list of contacts, filtering on a field in the account?

I want to build a workflow in PowerAutomate giving me all contacts whose account has a specific value in the "new_field1" field.

I have used the "Expand Query" in the CDS "Get List" : 
parentcustomerid_account($select=name,new_field1,new_fields2;$filter=new_field1 eq 'test' )

The workflow is running fine, but it's not taking the filter into account, and it's not giving me the three fields (name, new_field1, new_field2) in the results. No error message. What am I missing ? 🙂 

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @tissanfr 

 

So the problem here is, that I dont think you can use 3 Query options.

 

What I suggest doing is to create a Flow inside a solution so you have access to the Common data service (Current Environment) connector:

https://docs.microsoft.com/en-us/connectors/commondataserviceforapps/

 

This way you can use Select, Filter, and expand. Inside their own fields.


Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





View solution in original post

5 REPLIES 5
Jcook
MVP

Hello @tissanfr 

 

Could you share a screenshot of you flow?

 

Here is what the action should look like:

Jcook_1-1596640875388.png

 

 


Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





tissanfr
Frequent Visitor

How do I insert an image here? Using the camera icon and giving the link to a PNG image is not working 😞

I tried your syntax though, but it's refused, saying that the field is not available on the contact. My filtering is directly in the Expand Query field, like I saw online. 

@tissanfr 

 

Try copy and paste image into the reply.

 

Could you link the documentation you read?


Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





tissanfr
Frequent Visitor

Capture d’écran de 2020-08-05 17-36-50.png
i have used this page :
http://linnzawwin.blogspot.com/2019/12/power-automate-list-records-use-expand.html  (to see how to link to the account the right way)

 

as well as this page : 

https://community.dynamics.com/crm/b/dynamics-365-blog-with-manish/posts/expend-query-in-power-autom... (for the filtering syntax in the expand query field)

 


Hi @tissanfr 

 

So the problem here is, that I dont think you can use 3 Query options.

 

What I suggest doing is to create a Flow inside a solution so you have access to the Common data service (Current Environment) connector:

https://docs.microsoft.com/en-us/connectors/commondataserviceforapps/

 

This way you can use Select, Filter, and expand. Inside their own fields.


Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (5,096)