Power Automate - How To Filter Excel Date Columns Contains Blank/Non-Blank values)?
How to filter Excel date columns (Optional column which contains Blank/Non-Blank values) using Microsoft Power Automate?
The expression I used in my video as follows:
if(equals(item()?['DateOfBirth'], ''), '01/01/1990', addDays('1899-12-30', int(item()?['DateOfBirth']), 'dd/MM/yyyy'))
My Power Automate Profile
https://powerusers.microsoft.com/t5/u...
Power Automate Community
https://powerusers.microsoft.com/t5/M...
Twitter
/ mydevexperience