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.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,199)