Power Automate application

[RSorrentino]

I am learning Power Automate while trying to create a flow.

I need to search a users mailbox (this will be many) for unique email address (not internal email addresses) and then update a Microsoft Excel spreadsheet with the email address and the count of how many times that email has come up within a certain date range, possibly monthly. This could be expanded to include First and Last Name, Company, job worked and client. I have tried copilot but it does not work. Any help.

[Der-Geist]

Copilot? For Generating the report? Microsoft Graph API is a possible solution for grabbing the data. You likely want to use Graph API for the heavy lifting (grabbing and filtering data) and the Power Automate to pull the strings.