Unanswered

Error help the function was invoked with values of type 'String' and 'Integer' that do not match.'.

(0) Share

Report

Posted on by SPS-DEV-22

516

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

I get this error concerning this

Boxed in Red Column is a Calculated column in SharePoint list. I have the data being saved a Single line of Text. I have also tried Number. I get the same error:
values of type 'String' and 'Integer' that do not match.'.

how can I get when the value is -5 or greater to be used to trigger the flow?

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (0)

Michael E. Gernaey 53,315 Super User 2025 Season 2 on at

Like (0)

Report
Hi

Here is what you do. You need to convert the string to a number. Since the Column is a string format change the output to int as below

Step 1. Hover over the Days Su one you have. Type it into Notepad. Here is my example
Step 2: what the popup code in Notepad
Step 3. Delete the Condition from the Box so its empty
Step 4. in the code you wrote in NotePad, surround it with int() like this int(mytypedinstuff)

int(variables("mystuff"))

Step 5. Go back to the Condition and when you click in it and the Dynamic Windows comes up, click the Expression tab, Paste that line in and click OK

Feel free to post back and sometimes it can take a couple of tries to get it pasted correctly.

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report

Hi @SPS-DEV-22 ,

SharePoint calculated columns do not "play well" with Power Platform functions and really should be avoided except in the SharePoint interface itself. To test if this is the issue, put in a number column with the same value (you can do the calculation in Power Apps and populate it) and see if that works in the Flow as you require.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
SPS-DEV-22 516 on at

Like (0)

Report

new:
what do I remove from this:

@triggerOutputs()?['body/Days_x0020_Supervisor_x0020_Has_']

*****************************************************************************************************
I get this error:
Unable to process template language expressions for action 'Condition' at line '0' and column '0': 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.

this is what I have:
int('Days_x0020_Supervisor_x0020_Has_')

Was this reply helpful? Yes No
Michael E. Gernaey 53,315 Super User 2025 Season 2 on at

Like (0)

Report

Can you show me your trigger? Are you opening the Excel file based on a Trigger (like Created/Modified)? Or are you doing list Rows on the Table data?

Was this reply helpful? Yes No
SPS-DEV-22 516 on at

Like (0)

Report

it is a Sharepoint list column

Ok, I copied the number 5 etc. to another column I just created.
the sharePoint list column is a single line of text

the Power Automate only likes the expression "equal to"

if I try the equal to or greater than I get the same error.

I need to have it send the email message if the number is 5 or more.

Was this reply helpful? Yes No
SPS-DEV-22 516 on at

Like (0)

Report

here is the flow:

that is it, send a email when things are 5 days old or older in the SharePoint list.

Was this reply helpful? Yes No
SPS-DEV-22 516 on at

Like (0)

Report

for your step 1

How would I write this into the int( )

Was this reply helpful? Yes No
SPS-DEV-22 516 on at

Like (0)

Report

Maybe I'm going about this the wrong way..

I do have a date column called date sent to supervisor and if it is not approved +5 from there, then an email send me sent.

not sure how to do the "date sent to supervisor" + 5 days and status is still sent to supervisor then send email to supervisor reminding them to approve item

moving this to a new thread, since the calculated columns seem to be the issue.

New Thread:
Using the Date Column and Plus 5 days to send emai... - Power Platform Community (microsoft.com)

Was this reply helpful? Yes No
SPS-DEV-22 516 on at

Like (0)

Report

Maybe I'm going about this the wrong way..

I do have a date column called date sent to supervisor and if it is not approved +5 from there, then an email send me sent.

not sure how to do the "date sent to supervisor" + 5 days and status is still sent to supervisor then send email to supervisor reminding them to approve item\

Move the thread to this question:
Using the Date Column and Plus 5 days to send emai... - Power Platform Community (microsoft.com)

Was this reply helpful? Yes No
Michael E. Gernaey 53,315 Super User 2025 Season 2 on at

Like (0)

Report

Hi

Too many things happening and getting confused at once.

Time to Reset.
1. You asked about putting int around thid
But this is a TriggerBody output. That is why I asked if you have a custom Trigger Condition because the Apply to Each, listing rows would not produce a TriggerBody Output, only the Trigger does.

Are you saying in the Condition property, you have THAT expression? Instead of the Expression that would come from the SharePoint List rows would have something like items()?['MyColumn']

Just so you feel good about this.
I have an Excel, with a number column.
I added a condition where it checks if the Column is greater than 5 and it works fine.

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No