cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Enable to match date of birth coming from sharepoint lookup field

Hi,

 

I'm enable to match the the date value coming from sharepoint lookup field with the current date.

 

Screenshot (87).png      

below is the formula I'm using in condition 2 
@equals(formatDateTime(item()?['Name_x003a_DOB']?['Value'], 'MM-dd'), formatDateTime(utcNow(), 'MM-dd'))

it always goes to false state if even after the data entered in sharepoint is right.
Kindly help.
2 REPLIES 2
ScottShearer
Super User
Super User

@Anonymous:

 

I don't see anything obvious wrong with your expression.  I suspect the issue might be with the actual value you are retrieving from SharePoint and/or how referencing it.

 

Can you post a screen shot of your entire flow?  This will assist in trying to find a resolution.

 

Scott

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
Anonymous
Not applicable

Hi Scott,

I found the solution of it, it was the date which is retrieving in ISO 8601 time format and when we check the MM-dd of current date with it, it goes to the false state.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (6,470)