Hi, I have created a Bot which sends email whenever a new entry is created through a Entry form.
Email should be sent only when the value entered in “Fedex Number” field does not already exist in “Fedex Number” Column of the table. Basically, email should be sent for only new Fedex Numbers entered. I tried the following condition to check if Fedex Number already exists in Fedex Number column or not:
IN([_THISROW].[Fedex Number], Eldon_Laboratory[Fedex Number])
But it is always returning True. i.e. it is always sending email irrespective of new or old Fedex Number. Can someone suggest what am I doing wrong.