Unanswered

How to only include items greater than date field

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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:

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!

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)

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

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
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')

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!

Was this reply helpful? Yes No
v-bacao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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,

Was this reply helpful? Yes No