Announcements
Here is excel file with three column date(Today()),due date and item.
my flow looks like this:
Its output on my mail look like :
Hi @rohit7373
You need to convert the number to a date using the below expression.
addDays('1899-12-30',int(item()?['due date']),'yyyy-MM-dd')
@abm sir, can I use this code too : @equals(formatDateTime(items('Apply_to_each')?['DUE DATE'],'dd-MM-yyyy'),formatDateTime(utcNow(),'dd-MM-yyyy'))
I also wanted to know that why you have used 1899-12-30 there.
Thanking you
Rohit Kumar
Hi @rohit7373 ,
Because the value of the date field in the Excel table will be a number in Flow, we need to restore number to date first.
Please refer to this similar thread:
Solved: Excel file to list flow: date issue - Power Platform Community
Best Regards,
@v-bacao-msft @ sir,
Can I use this code too : @equals(formatDateTime(items('Apply_to_each')?['DUE DATE'],'dd-MM-yyyy'),formatDateTime(utcNow(),'dd-MM-yyyy'))
Please try to fill the following expression in Filter array:
@equals(addDays('1899-12-30', int(item()?['duedate']), 'yyyy-MM-dd'), utcNow('yyyy-MM-dd'))
Did you tried the above expression? What result you got?
Excel stores the date in numeric digits that's the reason we need to use the other expression which I suggested.
sir, all above logic is perfectly working but i am not able to take out "item" b after array filter:
Now i want to take out this "item:"b" as my output ,how to do it?
HI @rohit7373 ,
Please try the following method:
I am getting error when i use this expression.
GREAT THANK YOU,BUT STILL SOME PROBLEMS REMAINS PLEASE RESOLVE .
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
David_MA 252 Super User 2026 Season 1
11manish 169
Haque 154
