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!
Solved! Go to 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.
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.
@RogueCheddar Thank you for sharing what was wrong with me. Your forum post will help other users.
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
User | Count |
---|---|
85 | |
57 | |
42 | |
37 | |
33 |
User | Count |
---|---|
91 | |
73 | |
72 | |
60 | |
40 |