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

Newsletter Subscription Flag in CDS

Good day, everyone!

 

When using Power Automate to look at Contacts entity in CDS, I want to limit the query to just pull the Send Marketing Material flag, which is either Yes or No, and base my next action accordingly. To do this, I use the CDS action Get A Record. I am using the Contacts' Email as the identifier.

 

My problem is that I don't yet know how to write the query to limit the return to the entry for the Send Marketing Materials field under the Contacts entity. How would I write the query to put in the Select Query field, and do I need to use the Expand Query at all?Thanks in advance for all your time!

 

Screen Shot 2020-10-01 at 11.34.17 AM.png

1 ACCEPTED SOLUTION

Accepted Solutions
RogueCheddar
Frequent Visitor

N00b mistake. I see that the query isn't needed as it just passes all fields to the next action. My apologies for over-thinking it.

View solution in original post

2 REPLIES 2
RogueCheddar
Frequent Visitor

N00b mistake. I see that the query isn't needed as it just passes all fields to the next action. My apologies for over-thinking it.

askondo
Community Support
Community Support

@RogueCheddar Thank you for sharing what was wrong with me. Your forum post will help other users.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (3,721)