Newsletter Subscription Flag in CDS

[RogueCheddar]

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!

 

[RogueCheddar · Accepted solution]

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]

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