I have been banging my head against a wall... This may have been covered somewhere but I cannot find a solution.
This is an automated output to email:
Ideally I want the total number of days to show up as an integer but I can't figure out how to do it. I have tried multiple approaches and keep coming up empty. Any advice would be appreciated.
The flow runs every day at 9AM, if the day of the month is either 1 or 15 then the flow continues.
I get my Sharepoint list, Select the data, create the HTML table, Style it, create a CSV table then send the email.
I have tried changing the data type in Sharepoint as well, for some reason the hours per day comes across nicely, the only difference between the hours per day column and the total number of days column is that the latter is a calculated column.
Any attempt at formatting this column of data results in errors, help would be appreciated!!
