cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper IV
Helper IV

Right & Left function

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? 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Super User III
Super User III

Re: Right & Left function

@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."

View solution in original post

Highlighted
Super User III
Super User III

Re: Right & Left function

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.

View solution in original post

6 REPLIES 6
Highlighted
Super User III
Super User III

Re: Right & Left function

@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."

View solution in original post

Highlighted
Super User III
Super User III

Re: Right & Left function

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.

View solution in original post

Highlighted
Helper IV
Helper IV

Re: Right & Left function

Hi @mdevaney 

 

I have tried the funtion but it returns the same number (5.50) and not the .50.

Highlighted
Super User III
Super User III

Re: Right & Left function

@JB0007 

Revised my answer above.

Highlighted
Microsoft
Microsoft

Re: Right & Left function

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.

Highlighted
Helper IV
Helper IV

Re: Right & Left function

@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. 

 

RightFunction.png

 

RightFunction2.png

 

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

 

Thanks for your help 👍

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (6,321)