web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate How to compare 2 strin...

Power Automate

Unanswered

How to compare 2 strings using condition

(0) Share

Report

Report

Posted on by lisa_garcia

33

Hi guys

I´m trying to compare two strings using a condition but the result is always wrong... can anyone help me?

For example:

the value of compose 3 is 322,30 € (locale de-de), the value of compose 4 is 1000,00€ (locale de-de)

The check in the condition is: if compose 3 is equal or greater than compose 4

Why would the result be true?

Regards,

Lisa

Categories:

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

@lisa_garcia

Can you post screenshots of the outputs of Compose3 and Compose4 after a run please?

Was this reply helpful? Yes No
lisa_garcia 33 on at

Like (0)

Report

@ScottShearer sure
compose 4:

compose3:

sorry, it´s in german 🙂

Was this reply helpful? Yes No
Verified answer

Chriddle 8,434 Super User 2025 Season 2 on at

Like (0)

Report
Since string comparison works different from Number comarison, you first have to convert these string to numbers.

Remove the dot

Replace the comma with a dot

Remove the €

Remove the whitespace

Use float to convert

float( trim( replace( replace( replace( '1.000,00 €', '.', '' ), ',', '.' ), '€', '' ) ) )

Was this reply helpful? Yes No
lisa_garcia 33 on at

Like (0)

Report

Thanks so much! @Chriddle

Was this reply helpful? Yes No

Join the conversation