Forum Discussion
Reminder emails - Flow fails when date value is empty
DogAndPonyShow in your Get items action add a filter query of TargetCompletionDate ne '{null}' where {null} is an expression from the Expression tab in the dynamic content box. ne stands for not equal to. Make sure you include the single quotes around the expression. With this filter it will only bring back items from the list where the TargetCompletionDate actually has something in it so should avoid the error.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
DogAndPonyShow in your Get items action add a filter query of TargetCompletionDate ne '{null}' where {null} is an expression from the Expression tab in the dynamic content box. ne stands for not equal to. Make sure you include the single quotes around the expression. With this filter it will only bring back items from the list where the TargetCompletionDate actually has something in it so should avoid the error.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
RobElliott- thank you so much! That's worked a treat.
If I add a filtered expression 'TargetCompletionDate ne null' - the workflow no longer errors. Amazing.
Side question: under Dynamic content I don't see any of the SharePoint list columns (screenshot attached) - why would this be? Thanks.
DogAndPonyShow don't know, I'd have to see what your flow actions before it are.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
