Forum Discussion

Copper Contributor

Aug 01, 2024

Flow to send a daily email noting missing data in a SharePoint List

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 b...

Microsoft Flow

Jon_Lake

Brass Contributor

Aug 02, 2024

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')

Tim_Stanley_6959
Copper Contributor
Aug 07, 2024
Alas that is greek to this user so I do not know how to apply that idea.
- Jon_Lake
  Brass Contributor
  Aug 07, 2024
  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.
  - Rob_Elliott
    Silver Contributor
    Aug 07, 2024
    Tim_Stanley_6959 it would need to be the get items action, not the get item action.
    
    Rob
    Los Gallardos
    Microsoft Power Automate Community Super User.
    Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)