Right & Left function

(0) Share

Report

Posted on by JB0007

308

Hi Power Apps community,

I have a TextInput in my App which is a LookUp that returns a number from my SharePoint list. For example the LookUp returns 5.50 and display it in my TextInput1. I have another TextInput which I want it to display only .50. I have entered this code:

Right(Value(TextInput1.Text,3)

But it keeps telling me an error that it is expecting a Text value.

Someone knows how can I get passed this error?

Categories:

Building Power Apps

All responses (6)

Answers (2)

Sort by

Verified answer

mdevaney 29,993 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@JB0007
The LEFT and RIGHT functions do not work on Numbers. Do this instead.

Text(Value(TextInput1.Text), ".00")

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Verified answer

eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

Remove Value from the formula;
Right(TextInput1.Text,3)
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
JB0007 308 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @mdevaney

I have tried the funtion but it returns the same number (5.50) and not the .50.
mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@JB0007

Revised my answer above.
alrezac Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi,

Looks like you had some great help on this issue. I just wanted to add in a bit more information if you would like to learn more. Feel free to take a look.

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-left-mid-right

Regards,

Alex

-------

Community Support Team _ Alex Rezac
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
JB0007 308 on at

Like
a
(1)

Report
Copy link

Link copied!

@mdevaney

I have missed a step in first try. What I needed to do was to add another TextInput (TextInput3) and do the Right function from the TextInput2 with your formula.

Now I understand that your formula convert the number into text and from that I can use the Right function.

Thanks for your help 👍