I'm in the process of building an order management system as a model driven power app for one of our teams that runs a small advertising agency. I have a table for orders which includes a field to attach a .docx or .pdf file which contains a draft of the prospective ad.
I have built a flow which will be triggered on demand as part of a business process flow and I want it to grab the .docx file from the dataverse record and send it as an email attachment. The flow is 95% working, however the file attachment doesn't have a file extension so cannot be quickly opened by the recipient (the recipient can rename the file to add the file extension... but that's not an acceptable workaround).
In the flow I'm using the Dataverse 'download a file or image' action to grab the file. Then I'm using the 'Send an Email (V2)' action to compose the email. I have tried adding the .docx file extension to the 'Attachments Name' field but that causes the flow to fail.
Any ideas on how to successfully use flow to get a file from a dataverse record and send it as an email attachment with the full file extension?
Solved! Go to Solution.
Thanks @ChrisPiasecki. Wasn't quite what I was looking for but I found a way to make this work.
Just in case anyone else experiences this issue, I found that the Flow only worked if I populated the 'attachment content' field AFTER populating the 'Attachments Name' field (including file extension). If you edit the attachments name, then delete and then re-add the content to the attachment content field. Hope this may help if you've experienced a similar issue.
Hi @gobarrows,
You can query the File Attachments table to retrieve the file name of the file attachment.
---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.
Thanks @ChrisPiasecki. Wasn't quite what I was looking for but I found a way to make this work.
Just in case anyone else experiences this issue, I found that the Flow only worked if I populated the 'attachment content' field AFTER populating the 'Attachments Name' field (including file extension). If you edit the attachments name, then delete and then re-add the content to the attachment content field. Hope this may help if you've experienced a similar issue.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
28 | |
27 | |
23 | |
14 | |
10 |
User | Count |
---|---|
65 | |
51 | |
30 | |
29 | |
24 |