Dear power automate community,
I have a simple flow that sends and email notification after an item in my list has been modified. The Send an email notification (V3) sends the email, but the dynamic content that is gathered from my list does not match for 3 of several fields that it is returning. My email body looks something like this:
Body:
Dear [Requester DisplayName],
Your [Leave Type Value] request with ID#[ID] has been approved. For more details...
[Leave Type Value] Time Status
Days available at time of request: [Days Available]
Days used per request: [Days Requested]
Days remaining: [Days Remaining]
Next installment: [Next Installment Date]
Time balance after next installment: [Installment Balance]
* Please note: names in brackets correspond to Dynamic content; items in red identify problematic content.
Next Installment Date is a date field, but rather than returning the date in my list, I get the previous day. In other words, in one instance the field contained 12/1/2020. When I received the email, it returned 11/30/2020.
Days remaining and Installment Balance are calculated fields which are configured to have a single decimal place. When I look at the list, I may see 3.5 for Days remaining, but in the email, it returns: 3.50000000000000.
All other list field types are either number, choice or people and return accurate information.
Please help!
