Unanswered

Conditional action using string

(0) Share

Report

Posted on by lburmz

I'm sure this is me being thick, so apologies in advance.

I have a flow that parses the contents of an email and inserts them in a new row in an excel table (in Sparepoint). One of the things parsed is "Amount Paid" e.g. 100.00 (pretty sure it's still a string at this point, but it goes into Excel fine).

In parallel I want to send an email when the value of Amount Paid is more than a specified amount. If I use a conditional action with "Amount Paid" I get an error about conflicting type (string vs integer).

How do I convert Amount Paid to a number (decimal?) so that it can be used in the conditional action.

I have tried to initialise a variable:

Name = AmountGiven

Type = float

expression =

float(outputs('Amount_Paid'))

Then use AmoutnGiven in the condition, but that hasn't worked (error is "Skipped"). I must be missing a step somewhere.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (1)

Report
Hi @lburmz

You also need to convert number 20 (right side of the condition) as float type. The condition works correctly when we have compatible operands on both sides of the condition:

float('20')

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
lburmz 28 on at

Like (0)

Report

Unfortunately that hasn't solved my problem. I still get "skipped" on the condition, and it says there is no Input.

Was this reply helpful? Yes No
lburmz 28 on at

Like (1)

Report

figured it out. There was a terminate action in a parallel branch that was stopping everything. I also don't need the Initialize variable action.

Was this reply helpful? Yes No