Hi. I have a task to prepare a really complicated weekly report, that would contain a lot of specific informations taken out of different SharePoint lists on the company progress.
I am thinking out of box and instead of creating something really complicated, I would like to know: Is there any AI (with Power Automate connector) that would allow me to read my Power Automate outputs (like Get Items from Sharepoint list) and then, based on what is on that list and the prompt i provide, it will sent an email describing "we had X records, these people were focused on X, these on Y, it took them X hours to finish, etc.
I failed with AI Builder because it cannot read SharePoint lists.
Anyone completed a task like that before?
Thank you,
Wojciech