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
Super User
Super User

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





View solution in original post

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

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

Top Solution Authors
Users online (1,798)