Show the last 4 digits of a phone number.

(1) Share

Report

Posted on by Timm1

297

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:

General Questions

All responses (2)

Answers (0)

Timm1 297 on at

Like (0)

Report

Show the last 4 digits of a phone number.

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
Michael E. Gernaey 41,002 Super User 2025 Season 1 on at

Like (1)

Report
Show the last 4 digits of a phone number.

Hi

Use this expression

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