Hi there. I have a SharePoint list of users requesting access to a company intranet. Currently, I have a flow set up for when someone submits the access form, their information is put into the SharePoint List.
Now, however, I'd like an email to be sent to the employee when I modify the 'Date Fulfilled' column and their access has actually been granted. Initially, this column is blank.
Here's my current flow:
I have the trigger: when an item or a file is modified (connected to my Teams channel where this list is housed).
Then, Get changes for an item or a file (properties only).
Since: Trigger Window Start Token
Until: Trigger Window End Token
Next is Condition: Has Column Changed: Date Fulfilled is equal to true.
Lastly is to send an email if YES
WHAT am I doing wrong? The flow runs when it's supposed to and shows Succeeded, but I'm not receiving the test email. Inside the run detail, it's showing that the Expression Result is false even though the output shows "field_7": true. I have a feeling this is the issue, but I don't know how to solve. Any assistance is appreciated! Thanks!
