Unanswered

How to get 'Created' date into 10 chars then use that output in a condition testing list records to see if created date is seven days back

(0) Share

Report

Posted on by landsend

Hi, I have a 'Created' date I need to have that formatted to ten characters to use in a comparison test see if it is seven days back. In the Get Items 'query filter' I can't find an option to format 'Created' to ten characters for a valid test against addDays (seven days back using 10 characters).

And why don't I see 'Add Dynamic Content' is another question - on another post it was suggested that option went away.

I've tried just checking 'Director Approval' eq null then in another step format the 'Created' field entry then test but with no success. Maybe its the flow not sure. Here was a next attempt.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

David- 1,254 on at

Like (0)

Report
Copy link

Link copied!

I think the only problem is with your filter query. You need to format the date as 'yyyy-MM-dd' rather than 'yyyy.MM.dd' as Power Automate uses the ISO 8610 format for this. See What is ISO 8601? Proper Notation of Dates and Times Using ISO 8601 - ISO Update for details.

Was this reply helpful? Yes No
landsend on at

Like (0)

Report
Copy link

Link copied!

Hi, Appreciate the update on the ISO requirement for Dates and Times. That I found in output your suggestion did put the '-' dashes in the date to check against. I am still posed with how to get a long date format for 'created' into that same format. The create date format is long length and the comparison I'm working with is 10 characters and the comparison is I believe failing on that mismatch. I've tried to get the create date formated to 10 characters but don't think that newly formatted object is being picked up and used as the field to compare with and the question. Thanks.

Was this reply helpful? Yes No
David- 1,254 on at

Like (0)

Report
Copy link

Link copied!

You would use the expression formatDateTime(outputs('Get_item')?['body/Created'],'yyyy-MM-dd')

The red text could be different depending on the action where you are getting the output of the Created value.

Was this reply helpful? Yes No