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

How to only include items greater than date field

Hello,

I am trying to filter items from a list based on 3 conditions, send an email to the "Data.Provider", and write records to a new list.

 

The list:Capture2.PNG

 

3 Conditions:

Complete.Date >= 1/1/2019

Status = "Complete"

Modified by = !not me.

 

I am using basic editor and it looks like I can't just key in the date 1/1/2019. In my test runs I have gotten the errors:

InvalidTemplate. Unable to process template language expressions for action at line '1' and column '2626': 'The template language function 'greaterOrEquals' expects two parameter of matching types. The function was invoked with values of type 'Null' and 'String' that do not match.'.

 

 

InvalidTemplate. Unable to process template language expressions for action at line '1' and column '2628': 'The template language function 'greater' expects two parameter of matching types. The function was invoked with values of type 'Null' and 'String' that do not match.'.

 

What 2 parameters? 

Thanks in advance for any help!

 

 

Capture.PNG

PS - I have read other ways I might accomplish this but don't understand / can't get them to work.

 

Things like using "Switch" based on the Status field (because this only applies when Status in Complete)

or

Manual-->Get-->Filter-->Check if exists--> if not, Write it

2 REPLIES 2
yashag2255
Dual Super User II
Dual Super User II

HI @Anonymous 

 

You have to format the date and time string to achoieve this. 

 

In the condition, Completed is greater than part, on the right side remove that string from there and put the cursor in and on the tab at the ritght click on expression editor and use the expression: 

formatDateTime('2018-12-31T:00:00:00z','dd/MM/yyyy')

fhdhd.PNG

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

v-bacao-msft
Community Support
Community Support

Hi @Anonymous ,

 

First please check the format of Complete.Date is yyyy-MM-dd. If it is, you need to fill the following expression on the right side.

Expression reference:

formatDateTime('2019-01-01','yyyy-MM-dd')

In addition, for the other two conditions, if the type of Status is Choice, you need to select Status Value instead of Status.

When judging whether Modified by is the specified user, please select Modified by Email and fill the corresponding user's email address on the right.

Please try again.

 

Best Regards,

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

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,898)