Unanswered

How to update date and other calculated field in Flow, sent email action to reflect it correctly?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I have a flow setup that runs each time an entry is submitted based on a list form. its an approval workflow with basic send an email and update item action with some conditions.

I have a calculated date field and a calculated number field that is included in the body of the Send an email action. For some reason the calculated date field shows value with time zone and the Calculated number field shows many irrelevant zeros after the decimal point. Please see below screenshot of the email sample.

Hello User,

Your Request has been Approved! You should use your days credit 1.00000000000000 before 2018-10-12T07:00:00Z.

Best Regards,

Manager.

The Days credit value should be presented as 1.0 and date field should exclude the time zone info. So it should appear as 1.0 and 2018-10-12 (if this can be changed to 10/12/2018(mm-dd-yyyy), that would be ideal). Can someone please help me with a solution for this? Thanks in advance.

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (0)

v-yamao-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Anonymous,

It seems that you want to format both the types of Date time and Number.

Yes, we could format Date time using the function formatDateTime, however, currently there is no function can be used to format Number.

About the Date time, you could use the following function:

formatDateTime(triggerBody()?['CalculatedDate'],'MM/dd/yyyy HH:mm:ss')

About the Number, if you want to format the type of Number, please submit a request on Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

A screenshot for your reference:

Best regards,

Mabel Mao

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Mabel,

Thanks a lot for providing a solution, I will give it a try to make the change for the date field. Is there no other way to fix the Calculate dnumber field, I mean it is important to see these two values in the email. Any other suggestions?

Was this reply helpful? Yes No
ScottShearer 25,280 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

As a work around for the number issue, try the following:
1) use the div expression
2) Use your existing calcuation as the dividend (top number)
3) Use 1 as the divisor (bottom number)

I did some limited testing and this technique seems to work - you won't get back a decimal, you'll get back a whole number but hopefully that will work for you.

Scott

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Scott,

The calculated field assigns 0.5 as value to itself if certain date is populated in a date field. So there is no division in place.

Was this reply helpful? Yes No
ScottShearer 25,280 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Didn't realize that.....
But you also have access to the remainder via the Mod function.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi Scott,

Here is how my calculated field's formula looks like:
=(INT((WEEKDAY([Start Date]-1)+[End Date]-[Start Date])/7)*0.5)+(INT((WEEKDAY([Start Date]-7)+[End Date]-[Start Date])/7)*0.5)

What shoudl i change in the above to solve the decimal points issue in the flow email body?

Was this reply helpful? Yes No