Hello!
I’m tying to create a Zap where at midnight each night, the Zap is scheduled to find events in Microsoft Sharepoint for the upcoming day. Then an email would be created with details of the event(s) found.
The complication is that while I can use the “Find List Item in Microsoft SharePoint” action and filter the results to the upcoming day, the action only returns one event per day. So if there are multiple events in the same day and those events are full day events, only one will be returned.
Any ideas on how to solve this problem or another way of achieving the same outcome?
Thanks!
James