I need to create a flow that will send out a daily email showing all of the records in a SharePoint list that are missing the task approval dates (Approval Column). I have been playing around with building a flow but I am stumped when needing to enter the Query Filter info.
Hi Tim_Stanley_6959 , have you tried using the length expression to evaluate whether the field has data in it or not? The empty expression may also work with dates (I've not tried it), for example: if(empty('datefield'), = true, 'filter')
Hi Tim_Stanley_6959 , use a get items action to pull list items. In the 'Filter query' field of the action enter your target field name as part of an expression, for example: Approval_Date eq null. That will provide you with all the items where the field is empty.
