Update Content Type of Email Attachment

(0) Share

Report

Posted on by PeterKuehlian

Hi everybody

I try to create a automated solution for tracking my working hours.

I have therefore built a powerapps app where I can fill in a signature using PenInput.

I transfer the PenInput via Office365.SendEmail() to my inbox. A rule in my inbox sends the mail automatically to a subfolder in my inbox. Whenever a new mail arrives in this subfolder, my flow gets triggered.

It seems that everything works fine but one little detail always lets my flow fail: The action card in flow "Populate a Microsoft word template" is not able to fill the attached file in the placeholder in the template because it says, it is no png. When I was running the flow for testing I added a compose card to see what the content of the attachment is. My finding is, that it was of Content type: image / png.

I try to substitute the content type "image/png" by the content type "png", but I don't know how to do that.

Please help me.

This is my flow (works fine without attaching a picture from powerapps)

Here is my error warning. Saying:

Here is my approach to transform the email attachment to a variable. However, I want to change the content type to png.

Thanks

Peter

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

FoDelement 435 on at

Like (0)

Report
Copy link

Link copied!
Hello @PeterKuehlian

Try this in powerapps instead.

Office365.SendEmailV2("YourEmail@domain.com", "Sig image", "",{Attachments:Table({Name:"Signature.png", ContentBytes:PenInput1.Image, '@odata.type':""})})

(Assuming your peninput is called "PenInput1")

This should have the signature come to you as a PNG like you are requesting.

EDIT: Apparently we cannot opt out of emojis..

That reads ContentBytes: PenInput1.Image just without the space.

Was this reply helpful? Yes No
PeterKuehlian 79 on at

Like (0)

Report
Copy link

Link copied!
Hi @FoDelement

Thank you for your quick respond.
I tested the code in PowerApps as you suggested.

Unfortunetley that did not work 😞

In Flow the Content Type still gets recognized as "image / png".

In my Email Attachment in Outlook, I can open the png without any problems. But as soon as I want to fill the file in flow, the attached image does show as "image / png". However, the action card "populate a microsoft word template" can not work with this content type, as it is expecting a png or jpg file.

Do you have any other ideas?

I also tried to replace the content type: image / png with just png. That did work with a compose card, however i were not able to replace the content type within the file via flow.

This is my replace function:
replace(outputs('Compose_2'),'image/','')

I then tried to concat the content of the attachment and the content type like this:
concat(outputs('Compose_3'),outputs('Compose'))

Was this reply helpful? Yes No
PeterKuehlian 79 on at

Like (0)

Report
Copy link

Link copied!

Does anyone has another suggestion how to get this work?

Was this reply helpful? Yes No