I thought this would be simple but it doesn't seem it.
I am using this code:
COUNT(Filter("POP POINTS Database",AND(WEEKDAY(TODAY())=[DAY NO],[Patrol Name]="External",[Shift Type]="Day Shift")))>=COUNT(Filter("POP Point Reads",[Patrol Name]="External"))
Simply comparing 2 datasets. If the count of 1 equals the other I hoped it would send the notification once but it is sending the notification every time a new item of data is added despite the dataset not having the data fully written yet. I can see the data slowing dripping into the Google Sheet!
The numbers within the App says they are equal but they are not, if they were why would it send out the notification EVERYTIME! It should only send it when they are equal.
An action is simply copying data from 1 place to another. The hope was to create a notification when the action was complete.
LinkedIn
Twitter
