You’re offline. This is a read only version of the page.
Announcements
Hi Folks,
I'm looking to build a Power Automate Flow to export an excel table and send in the body of an email.
The automation works and we can clearly see the excel data listed in email. The issue is that there are two columns in the table that have data validation list dropdowns and they don't seem to be pulled into the email.
The intention would be to have the recipients reply to the original email and use the table and its data validation list dropdowns to input and select data. This would be to ensure we receive structured responses for reporting purposes.
As an example:
Column 1 would have currency options: "CAD", "USD", "Other", etc.
Column 2 would have reporting options: "Word", "Excel", "SharePoint", etc.
We want to force the recipients to select from these options in the email table.
Any assistance and or support you can provide would be greatly appreciated.
It seems that the outcome you're aiming for might require a different approach. The "Create HTML Table" method is primarily used for reporting data and doesn't inherently support interactive controls like dropdowns or text boxes.
To achieve the desired functionality, you can include the animal names within the table and provide users with a link to update the item. This link could lead to a SharePoint form or a Power Apps form where users can make their selections, and the choices can be recorded accordingly.
Feel free to reach out if you need further assistance in implementing this solution.
Share
Report
All responses (
Answers (
14,394
