Nov 03 2023 07:53 AM
I have followed this great tutorial for creating and sending digital certificates to event participants (https://techcommunity.microsoft.com/t5/educator-developer-blog/send-digital-certificate-to-event-par...), and everything worked except for the last step which is sending the email with the certificate attached. I am able to receive an email with the pdf attached however, the file is corrupted and I'm unable to open it. When I check the pdf file in my share point it is not corrupted so the issue seems to be in the step of sending the email.
I tried using base64ToBinary(base64(body('Convert_file'))), when I added this I was able to open the pdf attachment but the pdf was empty and the content was erased. Please let me know if there is any way to overcome this issue.
Nov 05 2023 04:19 AM
Nov 17 2023 02:17 PM
@Bayan000 I switched to the classic editor, but it didn't work for me 😞
Dec 07 2023 02:40 PM
@Bayan000 I am having this exact issue. Did you find a solution?
Dec 07 2023 08:24 PM
@punkymatta The issue is that in the new designer, when using send email V2, it does not grab file name and file content in the same manner as the old one. If you delete or modify your attachment section using the old designer, you will see that your options on getting the data from the one drive connector are different and once applied, your code should work.
Dec 17 2023 07:49 AM
@Bayan000 I can confirm switching back to old designer fixes this issue (as of 12/17/2023).
Dec 20 2023 08:26 PM - edited Dec 20 2023 08:29 PM
This should work like a charm
base64ToBinary(outputs('GET_FILE_CONTENT')?['body']?['$content'])
Jan 16 2024 12:33 PM
Feb 01 2024 01:19 AM
Mar 24 2024 12:38 PM
@Bayan000 I am still having this issue can you share your flow?
Mar 24 2024 12:39 PM
Mar 25 2024 08:53 AM
@daisysx1987 you will add it to your 'Compose' portion of your automation. The bigger thing you'll need to make sure (unless they've fixed this bug, haven't had any issues as of late) is to make sure you are not using the new designer mode as for some reason it populates item's slightly different and corrupts the file once created.
Hope this helps
Mar 26 2024 11:25 AM
Apr 06 2024 03:22 PM
@Bayan000 , Hi. I am using my organization's web based version of Power Automate which does not have an option for reverting to the old designer. Is there a fix for those of us stuck in the new designer? Thank you very much.
Jun 18 2024 02:15 PM
I've seen this kind of issue before with writing JPG files to Blob storage, there's something funky with the new editor that it mungs up parsing binary/base64 conversion unless the code is edited. I'm not sure if you can do this in Power Automate, but in logic apps in the code designer you can find the email attachment field and remove the outermost curly braces from the contentData string:
Jun 19 2024 07:47 AM
Thank you this helped!@WCarterMVUSD
Oct 01 2024 06:56 AM - edited Oct 01 2024 07:09 AM
hi all, I am new in this forum, but I wanted to share with you how I fixed it:
this has fixed my issue.
BR
TOmek