Unanswered

Error with power automate flow to identify changes in a excel file and send an email notification.

(0) Share

Report

Posted on by Vinit_Vichare

Hello Team, I have created a flow in power automate that that is expected to identify changes in a excel file and send an email notification. Here are the steps as shown in the screenshot:

When tested, the flow fails at step 'For Each' and error is shown as: "Unable to process template language expressions for action 'Condition_1' at line '0' and column '0': 'The template language function 'greater' expects two parameter of matching types. The function was invoked with values of type 'String' and 'Integer' that do not match.'."

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Vinit_Vichare ,

Nest an int() function outside of the dynamic content on the left side of Condition1.

Could you please tell me what your needs are for this flow?

I want to figure out why you have two For each loops in your flow.

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
Vinit_Vichare 16 on at

Like (0)

Report
Copy link

Link copied!

Hi, can we schedule a meeting to discuss on this?

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

Like (0)

Report
Copy link

Link copied!

Hi @Vinit_Vichare ,

I'm afraid not, I'm a forum technical support engineer, if you can, please try to give the exact information in the reply, thank you very much.

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
Vinit_Vichare 16 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-yetonggu-msft, my needs for this flow are to get an email notification once there are specific changes in the excel file. The flow should identify when some of the values in a column are dropped below a threshold value.

Was this reply helpful? Yes No