cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
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
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

Microsoft
Microsoft

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

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (34,702)