Power Platform Community Forum Thread Details

I need to create a Power Automate Flow which will read each and every files in a specifc SharePoint folder. The files names are always in "mm_dd_YYYY-XXXXYYYYZZZZ.xlsx" format.

The Flow should calculate whether the "mm_dd_YYYY" portion of the file name (which is the first 10 characters) is more than 90 days old from today or not. If the result is less that 90 days then No Action and if it is more than 90 days then those files only should be moved from that particular SharePoint folder to another Sharepoint folder and a mail containing all of these files in an HTML table should be sent across to a specific email address.

So far I have created this flow which is moving the files but I am not been able to do the HTML portion which'll send me all the files that are getting moved.

For your convenience, I am pasting the screenshots of the Flow. Would appreciate if anyone can help me with the rest. I sincerely believe, the Flow that I have created can still be simplified and shortened but due to limited knowledge I am not been able to design the same.