You’re offline. This is a read only version of the page.
128
We will probably achieve this via Power Automate and I wasn't sure whether to post here or in the Power Automate forum.
Our customers have paid Power Apps licenses, with email tracking turned on - so outbound emails from the model driven app are tracked in Outlook, with inbound replies automatically associated with the correct record in Dataverse. We do not have any Dynamics 365 subscription - this is purely a Power Apps paid license solution.
We want to identify records associated with an outbound email sent from the custom solution that have not been replied to. The email is sent from within the custom solution, and is an initial email (not a reply), so it will be the first in the email conversation thread - so parentactivityid is null.
What I am hoping to do is:
I have two questions
Thanks @LinnZawWin this is how I ended up doing it:
- populate one array with all sheds in particular status with outbound email with empty regarding column
- populate a second array with all sheds in particular status with inbound email
Then did an except type approach to return sheds in first array but not in second array. From review of the data it seems to be providing us the required data. The tricky bit was the EXCEPT - but I found a tutorial from Damo Bird that was close to what I needed - https://www.damobird365.com/efficien-union-except-and-intersect-great-method/.
Power Automate cloud flow would be an easy solution.
In a cloud flow, you can query the Emails and Order by Regarding column. Then, loop through and look for the Sheds record with only 1 Email.
#1
stampcoin
17
#2
mmbr1606
15
Super User 2025 Season 1
#3
ankit_singhal
11
Super User 2025 Season 1
Share
Report
All responses (
Answers (
