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

Power Automate Community

Twitter

[paradise]

Can you create a video to show how to delete Blank/Non-Blank values from Microsoft Forms responses

[akbarmahfuzalam]

Hey Ajith,
Can you make a video on- Creating Flow -Upload the excel sheet with Table on it to SharePoint List.

[solstice]

How about checking if date value is actual date value and not a different type of string? We could have a excel file that has both dates and strings in the column and only want to format the date but leave string values alone?

[MohammadAli-tsev]

Helpful video..
Can u plz let us know as how to skip (to format) a cell containing with text value like "NA".

I have a table where there is a date column and it contains NA and other comments as well where there is no date..
Plz help..I am stuck here.

Also, plz make a video on how to connect power automate flow with a shared file on Onedrive...

[mallikarjunjk]

How to get rows when one of its column is blank.? I need to collect the data for which date column is empty. I mean, need data for the goods not yet in our building.

[dineshkaromprakash]

Hi, can you please help me to filter empty cells in SharePoint list date column.?

[sindhukk]

Hi need help compare 2 excel and get the difference and update the difference in new sheet or new excel file ?plz help

[siddharthnanda]

Can we trigger the flow and read only those rows which will have current date?