Hi @MaryMoreno-3155
Do you want to send an email when the user modifies the IntakeOwner record (and make sure the value of this column is not empty)?
Here is a test for your reference:
First determine whether the value of the column is empty: the purpose is to determine whether the column is filled with value
Get changes for an item or a file (properties only) uses the version number to determine which columns have been modified between the current record and the previous record.
The newly created record has only one version number, so an error will be reported. In order to avoid this problem, it is necessary to determine whether the values of the two columns Created and modified are consistent: the purpose is to determine whether the record is a newly created record.
Since:
add(int(triggerOutputs()?['body/{VersionNumber}']),-1)
Condition :
Get changes for an item or a file (properties only) returns a Boolean value indicating whether these columns have been changed.
We select the column we need to judge. Then when it is true, it means that the column is different from the previous version.
Here is test:
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Best Regards
Cheng Feng