Send email with excel cells that are formatted

(0) Share

Report

Posted on by rjack

188

Hello,

I have a flow based on the solution provided here. This solution is working but there are many random cells that are highlighted in my table and would like those highlights included in the email.

Is this possible? is so please let me know.

EDIT: Also, how to I carry the date format?

Thanks

Categories:

Building flows

I have the same question (0)

All responses (11)

Answers (1)

Pstork1 68,707 Most Valuable Professional on at

Like (0)

Report

I don't think that's going to be possible. You can read the value of table cells from Excel, but the visible formatting is not brought over by the connector as far as I know.

Was this reply helpful? Yes No
rjack 188 on at

Like (0)

Report

Thank you @Pstork1. I'm assuming there's no other workflow to power automate which would create table based on unique email addresses and pick multiple rows for the same email address along with format and cell colours.

Was this reply helpful? Yes No
Pstork1 68,707 Most Valuable Professional on at

Like (0)

Report

There are ways to build the table and format specific cells, but no way that I know of to pick up that formatting from the formatting in Excel.

Was this reply helpful? Yes No
rjack 188 on at

Like (0)

Report

@Pstork1 Got it and thanks for the confirmation.
How about if I'm trying to pull information on to an email from a SharePoint list and not a excel? would that change the way I should design the flow and will it bring the formatting?

Was this reply helpful? Yes No
Pstork1 68,707 Most Valuable Professional on at

Like (1)

Report

Not really. The limitation is in styling the table created using the create HTML table action, not the data source.

Was this reply helpful? Yes No
rjack 188 on at

Like (0)

Report

@Pstork1
I just realized that the date from the spreadsheet is converted to numbers. how to I get it the dates back? I tried formatDateTime(triggerBody()?['Date'],'yyyy-MM-dd') and below is the error. I though the 'Date' is the column, but apparently not?

InvalidTemplate. Unable to process template language expressions in action 'Compose' inputs at line '1' and column '26660': 'The template language function "'formatDateTime'" expects its first parameter to be of type string. The provided value is of type 'Null'.

Was this reply helpful? Yes No
Pstork1 68,707 Most Valuable Professional on at

Like (0)

Report
Excel stores Dates and Times as a Serial whole number representing the number of days since 01/01/1900. So the formula to convert back to a full Date/Time is

addSeconds('1899-12-30',int(formatNumber( mul( float(ExcelDateValue),86400),'0')))

You can add your FormatDateTime to the outside of that if you want to remove any time component.

Was this reply helpful? Yes No
rjack 188 on at

Like (0)

Report

Thank you @Pstork1,.

Could you please help me with what and where I need to enter the formula? I'm not very familiar with these coding.

Currently I have this. Compose action called 'date format' has the formula that i mentioned earlier.

Was this reply helpful? Yes No
Pstork1 68,707 Most Valuable Professional on at

Like (0)

Report

You need to use it wherever you are retrieving a Date/Time value from Excel. From your screenshot I would say that is in the Date/Time fields you are appending to the Array in the YES side of your condition.

Was this reply helpful? Yes No
rjack 188 on at

Like (0)

Report
I'm getting expression is invalid. tried manually typing the below code as well.

addSeconds('1899-12-30',int(formatNumber(mul(float(ExcelDateValue),86400),'0')))

Also, I need to remove the date value I'm pulling from the spreadsheet (highlighted in yellow) but use the code to get the date values. correct?

Was this reply helpful? Yes No