Power automate - sending email from excel data received on the email

(0) Share

Report

Posted on by STA_

Hi,

I receive a weekly mail from on of my partners with an Excel file full of lines. this is excel has the same format.

I need to get the lines from this excel file, and send a mail to different clients with contents in the lines.

is this possible with the Power Automate?

Thanks

I have the same question (0)

All responses (10)

Answers (1)

Verified answer

v-xiaochen-msft on at

Like (0)

Report

Re: Power automate - sending email from excel data received on the email

Hi @STA_ ,

I did a test for you.

first(triggerOutputs()?['body/attachments']).name

dataUriToBinary(concat('data&colon;application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;base64,',first(triggerOutputs()?['body/attachments']).contentBytes))

first(outputs('Get_tables')?['body/value']).id

removeProperty( json( replace(string(items('Apply_to_each')),'@odata.etag','odataetag')),'odataetag')

removeProperty(outputs('Compose'),'ItemInternalId')

Best Regards,

Wearsky

Was this reply helpful? Yes No
STA_ 36 on at

Like (0)

Report

Re: Power automate - sending email from excel data received on the email

Hi Wearsky,

Thx.

I am receiving an error on the create file Step:

Unable to process template language expressions in action 'Create_file' inputs at line '1' and column '38624': 'The template language function 'dataUriToBinary' expects its parameter to be formatted as a valid data URI. The provided value 'data&colon;application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;base64,

Thx,

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report

Re: Power automate - sending email from excel data received on the email

Hi @STA_ ,

Please provide the screenshots of your flow.

Best Regards,

Wearsky

Was this reply helpful? Yes No
STA_ 36 on at

Like (0)

Report

Re: Power automate - sending email from excel data received on the email

Hi @v-xiaochen-msft

Below:

first(triggerOutputs()?['body/attachments']).name

dataUriToBinary(concat( 'data&colon;application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;base64,',first(triggerOutputs()?['body/attachments']).contentBytes))

first(outputs( 'Get_tables')?['body/value']).id

thx,

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report

Re: Power automate - sending email from excel data received on the email

Hi @STA_ ,

Please check the content in the red box.

Best Regards,

Wearsky

Was this reply helpful? Yes No
STA_ 36 on at

Like (0)

Report

Re: Power automate - sending email from excel data received on the email

hi,

thanks,

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report

Re: Power automate - sending email from excel data received on the email

Hi @STA_ ,

The forum’s reply system automatically converted my formula...( sad )

Please use the formula in the first picture.

Best Regards,

Wearsky

Was this reply helpful? Yes No
STA_ 36 on at

Like (0)

Report

Re: Power automate - sending email from excel data received on the email

Hi,

Fixed that error...

On the list i receive this error:

Unable to process template language expressions in action 'List_rows_present_in_a_table' inputs at line '1' and column '38625': 'The template language expression 'first(outputs( 'Get_tables')?['body/value']).id' cannot be evaluated because property 'id' cannot be selected.

Thx,

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report

Re: Power automate - sending email from excel data received on the email

Hi @STA_ ,

Is there a table in your excel?

My solution is based on the table. So did you create a table for excel ?

For example:

And could you show me the run history of your flow?

Best Regards,

Wearsky

Was this reply helpful? Yes No
STA_ 36 on at

Like (0)

Report

Re: Power automate - sending email from excel data received on the email

Hi,

yes

Somehow worked now.... thxxx

Was this reply helpful? Yes No