Show the last 4 digits of a phone number.

(1) Share

Report

Posted on by Timm1

302

Hello. I have a gallery that shows the name and phone number of a department. With the phone number, I would like to just show only the last 4 digits. I researched the Left,Right formula but I can't seem to find the correct formula. Below are my current formulas.

Gallery -

Filter(Office365Users.SearchUser({top:500}),StartsWith(Department,"Finance"), IsBlank(Department)= false,IsBlank(JobTitle)= false, AccountEnabled=true,CountRows(BusinessPhones) > 0)
 
Phone Label- 
First(ThisItem.BusinessPhones).Value
 
As of now, the phone number displays  +1-509-888-1234.  I would like the number to show x-1234.  (I would also like to add the x- in front as well)
 
Thank you!
 
Tim

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

Michael E. Gernaey 53,968 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi

Use this expression

"x-" & Right(First(ThisItem.BusinessPhones).Value, 4)

Was this reply helpful? Yes No
Timm1 302 on at

Like
a
(0)

Report
Copy link

Link copied!

Awesome! I had to change the Left to Right and that gave me exactly what I was looking for.

"x-" & Right(First(ThisItem.businessPhones).Value, 4)

Thank you so much!

Tim

Was this reply helpful? Yes No