Flow save failed with code 'InvalidTemplate' and message 'The template validation failed

(0) Share

Report

Posted on by DineshK_

207

Hi All ,

I want to remove the rows based on the joining date column in the excel file . Requirement is , IF joining date is greater than current month but same year then the rows should remove from the file and also IF joining date is greater than current year this rows also should remove .

For eg : If we have Joining date = 28/01/2025 and 12/09/2026 , then both the rows should remove.

but getting the below error when saving the flow .. also running long time for just 7k rows in the data source (Sample data). but original data would be more than 300k :(

How to overcome this error and performance for large datasets ?

or(
int(formatDateTime(items('Applytoeach')?['Joining Date'], 'yyyy')) > int(formatDateTime(utcNow(), 'yyyy')),

and(
int(formatDateTime(items('Applytoeach')?['Joining Date'], 'yyyy')) = int(formatDateTime(utcNow(), 'yyyy')),
int(formatDateTime(items('Applytoeach')?['Joining Date'], 'MM')) > int(formatDateTime(utcNow(), 'MM'))
)
)

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Expiscornovus 33,830 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @DineshK,

Just to double check, in the code snippet (below the screenshot) you shared the items functions are using an action with the name 'Apply to each' (a space is replaced by a underscore btw), however in your screenshot that name is 'Applytoeach'.

Have you updated the expressions after renaming the action? The name needs to be exactly the same.

Was this reply helpful? Yes No
DineshK_ 207 on at

Like (0)

Report
Copy link

Link copied!

@Expiscornovus Yes I have renamed the action name because i have created 2 more actions with same "Apply to each" .

So that i have renamed 1st one and based on that i have updated the expression.

Post that i have removed remaining apply to each actions.

Now both action name and expression is same right ?

What should i update in the expression?

Was this reply helpful? Yes No
DineshK_ 207 on at

Like (0)

Report
Copy link

Link copied!

@Expiscornovus Hey any clue pls ?
Still stuck with this job ..

Was this reply helpful? Yes No
Expiscornovus 33,830 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @DineshK_,

That seems to be correct, and it is still complaining about the reference message when you try to save the flow?

Otherwise try this approach.

- Rename the apply to each

- Remove your conditions with the expressions and add a simple condition like 1 is equal to 2 for example

- Save the flow (this way we now for sure the Rename activity has been picked up)

- Remove the 1 is equal to 2 condition and add the conditions back again to your Condition 3 action and save the flow again

Was this reply helpful? Yes No