Hello. This is my first time using Power Automate, and I mostly used the Copilot feature to build this flow. I am try to build a flow that will take a table from my spreadsheet, then when an item in the table says "Due," I want it to send an email to the appropriate person to alert them. My Excel sheet automatically updates based on the date, and that would change the cells in the tables to various things: "Not Due," "Due soon," "Due," and "Okay." I linked the correct table on the aforementioned spreadsheet, but it will not correctly read the value in the table, which leads to no email being sent. If anyone has any advice for a beginner, that would be greatly appreciated. I have attached multiple screenshots that will hopefully help with my poor explanation. Let me know if you need to see anything else
