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

Answered

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,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@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
Copy link

Link copied!

@ScottShearer sure
compose 4:

compose3:

sorry, it´s in german 🙂

Was this reply helpful? Yes No
Verified answer

Chriddle 8,644 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
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
Copy link

Link copied!

Thanks so much! @Chriddle

Was this reply helpful? Yes No

Join the conversation