
Hi All,
I have created a flow that successfuly filters a list in Sharepoint and emails a report with an html table at set intervals.
My current Flow is as below. The current output and desired output are as per subsequent images.
What changes do I need to make to my flow to get the desired output of the html table in the email? Basically I want currency sign in certain fields (as it is in the sharepoint list) and a row that subtotals these.
Please help as I have spent a lot of time trying to reach this outcome but no luck 😞 !
Thanks!
Hi @Anonymous,
I afraid that there is no any way to convert the value in the Cost and Payable field to a currency value with a $,
If you just want to summary the value in the Cost and Payable field of items which's Status value is equal to "Done", you could filter items which's Status value is equal to "Done" firstly, and then insert an summary item in the list, then create the html table with all items and the summary item, if you don't want the summary item to be in the sharepoint list, you could delete the summary item finally.
Best regards,
Alice