Enable to match date of birth coming from sharepoint lookup field

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

Sort by

ScottShearer 25,290 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No