Answered

Syntax needed - I am Lost!!!!

(0) Share

Report

Posted on by KM-25111106-0

Hello

I am new to power apps and the power fx language and I am in need of a formula. I hope someone can help. I want to fill this circle with a colour based on conditions. In this case If the value number of welds actually inspected (6) in this case) is greater than or equal to number of items for inspection (2 in this case), I want to turn green if its true and red if it is false. But I keep getting errors. I am pulling my hair out.

Categories:

Power Apps Pro Dev & ISV

All responses (5)

Answers (1)

Sort by

Suggested answer

mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
hey

can u try this:

If( Value(DataCardValue12.Text) >= Value(DataCardValue11.Text), Color.Green, Color.Red )

if it was helpful please mark as verified answer

cheers
KM-25111106-0 6 on at

Like
a
(0)

Report
Copy link

Link copied!

That works an absolute treat. Thank you so much. One last query. In gallery, I want to add the outcome of that so you can see it at a glance. I try the same formula but it either colours them all red or green and not specific to the record. Any help?
Verified answer

mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!
hey

in a gallery u need the ThisItem reference

so you can try this:

If( Value(ThisItem.NumberOfWeldsActuallyInspected) >= Value(ThisItem.NumberOfItemsForInspection), Color.Green, Color.Red )

you might need to rename the column name.

please also make sure, to mark the answer as verified,

cheers
KM-25111106-0 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello again

Hope I marked this solution correctly for you.

Can I ask another thing?

I wanted to be able to calculate some Sums based on a selection value. In this instance, I want to select the different contract no, the two boxes below populate with adding up the respective values from the galleries for that contract number. I am so new to this. Any help is greatly appreciated.
mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

What do you want to sum Here?

I only see one contract Number