Hey guys,
I'm starting to like this community as a resource. I've been a lone wolf for nearly a year, learning Dynamics and Power Apps/Automate the hard way (somewhat intentionally) to build our company's CRM. The foundation is built and I have a few BPFs running for the sales team. Next, I'm focused on workflows to enable efficient processes for multiple departments. Unfortunately, my lack of Microsoft experience has made it difficult to pick up Power Automate.
Here's where I could use some help-
I've built my first successful workflow that checks the Opportunity Dataverse table for new Opps created that day. It then uses a filter array to remove anything created before today. I used the 'Select' action to map columns/values for an HTML Table that's automatically generated. Then my condition checks the table output for data. If no new Opps exist, the workflow ends. If there are new rows, the table is posted to the body of my email which is sent once per day at midnight.
After looking through the forums, I've found several postings similar to my requirement, but haven't quite figured it out yet...
1. I'd like to insert a hyperlink to my table row(s) that redirects the recipient to that specific record in the CRM (D365)
2. I'd like to reformat my table in the email. It's very compact and doesn't look neat and clean by any stretch.
Thank you in advance for your time and assistance! See below for workflow references-
I could use some clarification here- is it necessary to format items like this, or should I be using the dynamic insert for column names?
Automatically generated
My condition
![]()
