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:
- find all shed records with statuscode eq to "Enquiry" - SHEDS array
- find all outbound emails with parentactivityid eq null for Sheds in SHEDS array - EMAILS array
- remove from EMAILS collection any emails where the activityid is referenced in parentactivityid of any subsequent inbound emails (because that assumes customer has replied).
- this will leave me with a list of emails not replied to (I think)
I have two questions
- Is there an easier or better way to identify outbound emails not replied to than what I've described? (Using Power Apps license, not D365 license)
- Is my logic sound?
