Hi,
I'm very new to Power Automate so apologies if this is obvious - it seems very simple so I can't understand why it's not working.
I'm trying to build a simple flow, that will send out emails to people once from an excel spreadsheet. New people will be added over time, so in theory I want the flow to run once a day, to send out the relevant communications to any new additions to the spreadsheet.
The spreadsheet has a "Date email sent" column - in theory, if this column is blank (or contains some kind of text to indicate emails have not been sent yet), I want Power Automate to send the email to the email address on the same row, and then update the "date email sent" cell with todays date, so that next time it runs this row will no longer be actioned.
However, I'm running into one consistent problem: the expression result is false every time, even though as far as I can see, I have the condition set to "No", and that is exactly what is present in the excel table, no extra spaces, capitalisation the same etc.
I'm not really sure what I'm doing wrong here, it seems very basic and straightforward?
It is currently set to a button flow but I plan on switching to automated once working as intended.
