cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NewUser22
Helper I
Helper I

Filter and retrieve only flows

Hi guys,

 

I'm trying to use condition to filter flows that are created today using "Flow Creation Time" and "utcNow()". 

The idea is to use list flow as admin action and use apply to each and write the data into excel.

I have built the flow but stuck at the part to filter flows using conditions"

 

Thanks!

 

Error>> Unable to process template language expressions for action 'Condition' at line '1' and column '2939': 'The template language expression 'formatDateTime(body('List_Flows_as_Admin')['createdTime'],'M/dd/yyyy')' cannot be evaluated because property 'createdTime' doesn't exist, available properties are 'value'. Please see https://aka.ms/logicexpressions for usage details.'.

1 ACCEPTED SOLUTION

Accepted Solutions
v-litu-msft
Community Support
Community Support

Hi @NewUser22,

 

Please try to correct the expression like this:

formatDateTime(item()?['properties/createdTime'],'M/dd/yyyy')

 Screenshot 2020-12-16 170544.jpg

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-litu-msft
Community Support
Community Support

Hi @NewUser22,

 

Please try to correct the expression like this:

formatDateTime(item()?['properties/createdTime'],'M/dd/yyyy')

 Screenshot 2020-12-16 170544.jpg

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

annajhaveri
Super User
Super User

Hello,

 

Put the following in left side of your condition to compare the todays date and flow created date

 

 

equals(formatDateTime(items('Apply_to_each')?['properties/createdTime'], 'yyyy-MM-dd'), formatDateTime(utcNow(), 'yyyy-MM-dd'))

 

 

 and on the right side of condition provide true expression, as shown in below screenshot

 

Screenshot 2020-12-16 164323.png 

Regards,
Anna Jhaveri

If I have answered your question, please mark the post as Solved to help other users to identify the correct answer
If you like my response, please give it a Thumbs Up.

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,287)