Unable to open Excel File sending from Onedrive with the hlep of Outlook

[AmolMane]

Hi All,

I have to send an email with attaching  few excel files to my team members on daily basis, i have stored those files on my onedrive.

I have developed power automate flow which sent an email from my outlook attaching excel files from my ondedrive folder to respective DL (to my other team members) on daily basis at 9 am. i could send it but when we tried to open those files from email it's giving error as below. Excel cannot oepn the file-------"filename.xlsx" ,

flow looks

[CFernandes · Accepted solution]

Hey Mate,

Can you please confirm if you are passing the file  - @{body('Get_file_content')['$content']} 

Try to decorate theFile_Content with base64ToBinary() –

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

[AmolMane]

Yes i am using body('Get_file_content')['$content'], 

where should i use base64ToBinary(),please help,  i tried with above expression, but no luck getting failed error msg.

(Unable to process template language expressions in action 'Append_to_array_variable_2' inputs at line '1' and column '15463': 'The template language function 'base64ToBinary' was invoked with a parameter that is not valid. The value cannot be decoded from base64 )

[AmolMane · Accepted solution]

Hey i got it, i tried as 

base64ToBinary(body('Get_file_content')['$content'])

thanks for your support!!

[CFernandes]

Hey Mate @AmolMane 

I am glad that your problem has been resolved 🙂

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.