Answered

After If statement string value not showing but number value does

(0) Share

Report

Posted on by Beaujon1

Does anybody know what I am doing wrong? Also how can I make it so that I don't have to use the Value() function al the time?

This works:

If(
Value(maandenAfschrijven.Text) > 0;
Value(mdmBedrag.Text) * Value(maandenAfschrijven.Text) / loopTijd;
Value(mdmBedrag.Text) * Value(restwaarde.Text) / Value(aanschafprijs.Text) <= Value(restwaarde.Text);
1 + 1;
Value(mdmBedrag.Text) * Value(restwaarde.Text) / Value(aanschafprijs.Text)
)

But this doesn't

If(
Value(maandenAfschrijven.Text) > 0;
Value(mdmBedrag.Text) * Value(maandenAfschrijven.Text) / loopTijd;
Value(mdmBedrag.Text) * Value(restwaarde.Text) / Value(aanschafprijs.Text) <= Value(restwaarde.Text);
"Betaal alleen restwaarde!";
Value(mdmBedrag.Text) * Value(restwaarde.Text) / Value(aanschafprijs.Text)
)

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Sort by

rebeccas 2,591 on at

Like
a
(1)

Report
Copy link

Link copied!

I'm sorry but unless my eyes are playing tricks on me I don't see any difference between the two statements you have above. Can you explain further on that?

As for the Value() <-- I do normally still put mine as you have. But you can set your Text Input to Number format instead of Text and then just have TextInput1 * TextInput2 and it works without the Value on everything. I have only used it when displaying so you could possibly still need it in a place or two when actually Patching to your data source, I have not tested that side yet.

Was this reply helpful? Yes No
Beaujon1 28 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey thanks for your response. I've edited the initial post. It's about the string: "Betaal alleen restwaarde!". It isn't showing on my text label.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!

@Beaujon1

If you get tired of typing Value(), you can just use *1 That converts text to a number. IMHO, this shortcut makes formulas much easier to read.

My 10th grade English teacher told us "Brevity is the soul of communication".

Was this reply helpful? Yes No
rebeccas 2,591 on at

Like
a
(0)

Report
Copy link

Link copied!

It is because the first half you asking it to show a text - "Betaal alleen restwaarde" and the second half you asking for a number. Change it to this and should be good:

If(
Value(maandenAfschrijven.Text) > 0;
Value(mdmBedrag.Text) * Value(maandenAfschrijven.Text) / loopTijd;
Value(mdmBedrag.Text) * Value(restwaarde.Text) / Value(aanschafprijs.Text) <= Value(restwaarde.Text);
"Betaal alleen restwaarde!";
Text(Value(mdmBedrag.Text) * Value(restwaarde.Text) / Value(aanschafprijs.Text))
)

Was this reply helpful? Yes No
Beaujon1 28 on at

Like
a
(0)

Report
Copy link

Link copied!

I mean that when I do the first formula with 1+1 the text label shows 2. But when I use "Betaal alleen restwaarde!" the text label is empty.

Was this reply helpful? Yes No
rebeccas 2,591 on at

Like
a
(0)

Report
Copy link

Link copied!

It is because you currently have it showing a number value. That is why the number response works but not the text. You need to make it where either option it can show (the number or the text) is either both numbers or both text. Since you can't make the text a number you have to make the number show as a text value. When I tested it on my end that fixed it for me.

Was this reply helpful? Yes No
Beaujon1 28 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey Rebeccas thanks for your time. But what determines what kind of value the text label can show? I've already set it to string. I've added a screenshot.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,419 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
HI @Beaujon1 ,

@rebeccas is correct in the approach - you need the field to have a consistent value - and this can only be Text as one of your options it Text. Also to save a bit of typing, you can do it this way

With( { wMdm:Value(mdmBedrag.Text), wMaa:Value(maandenAfschrijven.Text); wRes:Value(restwaarde.Text); wAan:Value(aanschafprijs.Text) }, If( wMaa > 0; Text(wMdm * wMaa / loopTijd); wMdm * wRes / wAan <= wRes; "Betaal alleen restwaarde!"; Text(wMdm * wRes / wAan) )

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.

Was this reply helpful? Yes No
Beaujon1 28 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you very much for the clarification, that worked. So I changed one part of the formula to Text(Value(mdmBedrag.Text) * Value(maandenAfschrijven.Text) / loopTijd);

Also @rebeccas thank you very much.

Was this reply helpful? Yes No