Unanswered

Date format

(0) Share

Report

Posted on by Sridhara

I am trying to create a flow to send auto emails when its birthday of an employee and the flow is failing in condition saying

"expressionResult": false

Please help, I am trying to retrieve the DOB from sharepoint list and it is in "dd-MM-yyyy" format

There is compose flow used to get current date with expression formatDateTime(utcNow(),'MM-dd')

The output is showing as current date with "MM-dd"

Categories:

Building flows

I have the same question (0)

All responses (35)

Answers (0)

rzaneti 4,241 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Sridhara ,

In your condition, when entering the DOB from SharePoint List, add the following expression, replacing the text highlighted in yellow for the dynamic content of your DOB column:

In the other side of the condition, you will have your formatDateTime(utcNow(),'MM-dd').

Let me know if it works for you or if you need any additional help!

-------------------------------------------------------------------------
If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.
http://digitalmill.net/

Was this reply helpful? Yes No
Sridhara 36 on at

Like (0)

Report

thanks, let me try

Was this reply helpful? Yes No
Sridhara 36 on at

Like (0)

Report

No still same error

Was this reply helpful? Yes No
rzaneti 4,241 Super User 2025 Season 2 on at

Like (0)

Report

Could you please share the raw outputs from your 'Get items' or 'Get item' action?

To access the "raw inputs", go to the 'flow details' page and click in one of the previous runs:

Once you do it, you will be in the 'flow run page', which may look like this:

Go to the 'Get items' or 'Get item' action and click in it to expand the details. Then click in "Show raw outputs" in the OUTPUT section. In some cases, this button appears as 'Click to download':

It will display a sidebar on the right side of your screen containing this JSON notation (if you had the 'click to download' option, it will open the outputs in a new tab):

Find the "body" property. It is always after the "headers" property. Make sure to remove any sensitive content from the image before sharing. You also can find more details about how to access the outputs in Power Automate in this article that I wrote recently: http://digitalmill.net/2023/06/29/how-to-access-the-raw-outputs-in-power-automate/

Was this reply helpful? Yes No
Sridhara 36 on at

Like (0)

Report

Was this reply helpful? Yes No
annetoal 1,934 Moderator on at

Like (0)

Report

Please show the outputs not the inputs.

Was this reply helpful? Yes No
Sridhara 36 on at

Like (0)

Report

{"body":{"value":[{"@odata.etag":"\"1\"","ItemInternalId":"1","ID":1,"Title":"*******","field_1":"****************","field_2":"************************","field_3":"2023-05-14","field_4":"2023-08-05","field_5":0.0,"Modified":"2023-08-11T09:57:41Z","Created":"2023-08-11T09:57:41Z","Author":{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser","Claims":"i:0#.f|membership|****************","DisplayName":"****************","Email":"*****************","Picture":"*****************************/_layouts/15/UserPhoto.aspx?Size=L&AccountName=****************","Department":"ICORE- CIS","JobTitle":"***************"},"Author#Claims":"i:0#.f|membership|*******************","Editor":{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser","Claims":"i:0#.f|membership|*************","DisplayName":"************","Email":"***************","Picture":"***************/_layouts/15/UserPhoto.aspx?Size=L&AccountName=******************","Department":"ICORE- CIS","JobTitle":"*************"},"Editor#Claims":"i:0#.f|membership|******************","{Identifier}":"Lists%252fWishes1%252f1_.000","{IsFolder}":false,"{Thumbnail}":{"Large":null,"Medium":null,"Small":null},"{Link}":"*************************/_layouts/15/listform.aspx?PageType=4&ListId=3cb54262%2Da1f0%2D48ff%2D85c7%2D02d34437663e&ID=1&ContentTypeID=0x01006AFBC2EBCC4D9D479C3627829A5ED332001BAB9479B484134EA55D20CCB1C053DD","{Name}":"20474972","{FilenameWithExtension}":"***************","{Path}":"Lists/Wishes1/","{FullPath}":"Lists/Wishes1/1_.000","{HasAttachments}":false,"{VersionNumber}":"1.0"},{"@odata.etag":"\"1\"","

part of the output

Was this reply helpful? Yes No
annetoal 1,934 Moderator on at

Like (0)

Report
I formatted the output for @rzaneti and anyone else who's following:
{ "body": { "value": [{ "@odata.etag": "\"1\"", "ItemInternalId": "1", "ID": 1, "Title": "*******", "field_1": "****************", "field_2": "************************", "field_3": "2023-05-14", "field_4": "2023-08-05", "field_5": 0.0, "Modified": "2023-08-11T09:57:41Z", "Created": "2023-08-11T09:57:41Z", "Author": { "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", "Claims": "i:0#.f|membership|****************", "DisplayName": "****************", "Email": "*****************", "Picture": "*****************************/_layouts/15/UserPhoto.aspx?Size=L&AccountName=****************", "Department": "ICORE- CIS", "JobTitle": "***************" }, "Author#Claims": "i:0#.f|membership|*******************", "Editor": { "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", "Claims": "i:0#.f|membership|*************", "DisplayName": "************", "Email": "***************", "Picture": "***************/_layouts/15/UserPhoto.aspx?Size=L&AccountName=******************", "Department": "ICORE- CIS", "JobTitle": "*************" }, "Editor#Claims": "i:0#.f|membership|******************", "{Identifier}": "Lists%252fWishes1%252f1_.000", "{IsFolder}": false, "{Thumbnail}": { "Large": null, "Medium": null, "Small": null }, "{Link}": "*************************/_layouts/15/listform.aspx?PageType=4&ListId=3cb54262%2Da1f0%2D48ff%2D85c7%2D02d34437663e&ID=1&ContentTypeID=0x01006AFBC2EBCC4D9D479C3627829A5ED332001BAB9479B484134EA55D20CCB1C053DD", "{Name}": "20474972", "{FilenameWithExtension}": "20474972", "{Path}": "Lists/Wishes1/", "{FullPath}": "Lists/Wishes1/1_.000", "{HasAttachments}": false, "{VersionNumber}": "1.0" }, { "@odata.etag": "\"1\"", "

Was this reply helpful? Yes No
annetoal 1,934 Moderator on at

Like (0)

Report

Are field_3 or field_4 the dates you are trying to use?

Was this reply helpful? Yes No
Sridhara 36 on at

Like (0)

Report

Thank you, yes

Was this reply helpful? Yes No