Issue with get attachment from mail / create (excel) file in SharePoint

[Anonymous]

Hi All,

I have an issue with getting the attachment from an email and creating a file in my SharePoint folder.

It looks like my flow runs fine without any issues but when I check my SharePoint folder my .xlsx file is like 10 times smaller and I can't open my document.

Could someone help me with the issue, below the flow I have created:

It creates this file (which should be around the same size as the others:

When I open the file I get the error bellow

Does anyone know how I can solve my issue?

Thank you!

Kind Regards,

Ramon

[DamoBird365]

HI @Anonymous 

I notice you are viewing the file from Windows and it is in the process of sync'ing via OneDrive desktop client (as it shows the blue cloud icon).  Have you attempted to load the file in the browser via the same path?  It may be that the file is yet to sync locally?

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

[Anonymous]

Hi @DamoBird365

Thank you for your response. I have checked in SharePoint Online, and the file have the same size and issue when I am trying to open it.

Kind Regards,

Ramon

[DamoBird365]

Hi @Anonymous 

Sorry about that, I guess you now need to explore the history of the flow.  

Looking again, you appear to have use attachment contents for the create file (which is from the email trigger).  I think you need to use Content Bytes as that is from the get attachment action.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here

[Anonymous]

Hi @DamoBird365 

I have tried to add "Content Bytes" where the item gets created (on the get attachment action Message ID and Attachment ID there is no "Content Bytes" available. But it still gives me the same error/issue, hereby my flow:

Kind Regards,

Ramon

[DamoBird365]

Hi @Anonymous 

If I use attachment contents I get 

but with content bytes - it opens...

So, I think we need to move back up your flow and check everything else.  Because your apply to each was built off of the attachment contents, it will be based on the wrong fields too.  

Can you check that your apply to each matches mine below - i have added the expression in comments, just hover your mouse over each dynamic field and if wrong, remove and re-add.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

[Anonymous]

@DamoBird365 

Strage, my apply to each looks like the same its only missing the @TriggerOutput() body/attachements line

In Message id, I use the Message ID and in Attachment id, I use the Attachments Attachment ID as bellow

Kind Regards,

Ramon

[DamoBird365]

Hi @Anonymous 

My recommendation would be to delete the original apply to each and create the following action:

It will automatically build the apply to each for you and then you can add in the create file action and hopefully it will all work for you.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

[Anonymous]

Hi @DamoBird365

I have deleted the whole flow and created a new one with the actions in your last post, but it still gives me the same issue.

In the filename, I have changed .xlsx to .xls to check if I could open the Excel and with what value it appears.
It should be a table with numbers but it looks like below, could there be some issue that the flow doesn't get a correct attachment?

Kind Regards,

Ramon

[DamoBird365]

Hi @Anonymous 

It should just work!?  Really strange. 

Do you want to copy the strange text into https://www.base64decode.org/ and see if it will decode it for you.  Might give you an idea of what is being saved to the file.

Does your apply to each run once by the way?  I.e. just one attachment?  Have you tried sending your test email account a brand new excel file that is definitely from Excel Online xlsx?

Damien

[Anonymous]

Hi @DamoBird365 ,

I have tried to decode (autodetect, UFT, ISO) but none could decode the text into something readable.

So I tried to use another .xlsx, just a plain sheet with some data and this file does works perfectly fine, so it looks like the issue has something to do with the file that I want to extract via Power automate. But I have no clue what this could be. 

If I just for example drag and drop the file from my mail to the desired destination there is no issue.

Any clue?

Kind Regards,
Ramon

[DamoBird365]

Hi @Anonymous 

Maybe try create file action with the original file name including extension - when an email is received.  Maybe it's not xlsx?  I think you are going to have to trial and error and look over the history.  Sorry I cannot be of further help here as it isn't making sense and I guess we are missing something.

Damien

[Anonymous]

Hi @DamoBird365,

I understand, I will check if I can find something by keep trying, If I find something I will let you know!
At least thanks for your support on this one!

Ramon

[DamoBird365 · Accepted solution]

Hi @Anonymous 

I understand you are now up and running after we worked on this remotely.  We believe it is to do with your filename (but I wonder if somewhere the logic wasn't right too), it may well be that you need to concat the string with the date e.g. concat('Aging ',formatdatetime(utcnow(),'dd-MM-yyyy'),'.xlsx') but please let me know how you get on.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

P.S. take a look at my new blog here

[Anonymous]

Hi @DamoBird365 ,

Thank you so much for your help, after we had contact remotely I tried some few things and the solution that I have now works for me

So the issue was that the get attachment function picked up all attachments from my email (including the Signature img from the sender). Somehow when I wanted to create the .xlsx file it tried to create an .xlsx file from the signature img...

With you adding the name of dynamic content I could figure out the way how to extract the file in the correct way, but I still needed to format the title so my PowerBI report could pick it up more properly.
So I created this condition that the get attachment only picksup the .xlsx file(s) from the email and now with the "old" file name formatting it works 🙂

Check my flow bellow:


Thank you so much!
Ramon

[DamoBird365]

@Anonymous I'm chuffed to have been part of it.  Good luck with the developments in the future and you know where we are 😉

[Sairam_pera]

In same scenario could you please tell me how to replace the content with .xls

[jaydenli]

After quite some research I realised it was caused by a small oversight in the very first step. 

The included attachment is defaulted to 'No', and should be 'Yes'.

Don't know why, then the email still got filtered out but without attachments - so the created files are empty or invalid. 

This is like a man-made design error. See attached picture: