
Announcements
I am working on my first Power Automate project.
I wanted to ask, would I be able to integrate my emails on outlook with this spreadsheet. The email which I will receive will be a default 'yes' or 'no'. Accompanying with this spreadsheet will be master spreadsheet with the names of the customers with their member numbers. Could it be possible to automatically sync my email to get a Yes (Y) or No (N)?
There are multiple actions that you can execute with Power Automate using Outlook and Excel connector yes. You can check if the emails contain "Yes" or "No" and then you can populate an Excel file that contains a table. This is possible using Power Automate yes.
Sorry if I misunderstood your question, you can refer to the following example that uses Outlook and Excel: https://powerusers.microsoft.com/t5/Connecting-To-Data/flow-add-row-to-excel-when-receive-email/td-p/17715
Best Regards,