cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TSundar
Regular Visitor

Phone Number Auto formatting not working in PowerApps form

Hi,

I have PhoneNumber field is Single line of Text type column in my SP List, When I enter 10 value in this field it's automatically change format like "###-###-####" as below screen shot,

TSundar_0-1622528673850.png

 .I have tried to use the following formula in the Default property of the Datacard Text(Parent.Default,"[$-en-US]###-###-####") like as below screen shot,

TSundar_1-1622528866007.png

 

But it doesn't affect the results as highlighted results

TSundar_2-1622528945536.png

 

What is the right formula that will display the phone number format that I mentioned?

Can someone please provide an example?

Any help will be greatly appreciated.

Thank You.

1 ACCEPTED SOLUTION

Accepted Solutions
CNT
Community Champion
Community Champion

@TSundar try this,

Text(Value(Parent.Default),"[$-en-US]###-###-####") 

View solution in original post

5 REPLIES 5
CNT
Community Champion
Community Champion

@TSundar try this,

Text(Value(Parent.Default),"[$-en-US]###-###-####") 

View solution in original post

v-qiaqi-msft
Community Support
Community Support

Hi @TSundar,

Do you want the input number to be formatted as you expect once you input something?

Could you please share a bit more about the scenario?

Actually, the Text input control could not display the text string as a formatted way once you input.

In other words, the formatted text string will not display in real time.

I have a similar thread here you could check for reference.

Set the OnChange property of the Text input as below:

Set(VarPN,Text(Value(DataCardValue8.Text),"[$-en-US]###-###-####")) 

Set the Default property of the Text input as below:

VarPN

Once you input something different, the Text input control will display the number as the phone number format.

v-qiaqi-msft_0-1622535799910.png

Regards,

Qi

 

 

 

Best Regards,
Qi
CNT
Community Champion
Community Champion

@TSundar Just wondering, if my solution worked for you 🤔.

 

Please remember to give a 👍 and accept the solution as it will help others in the future.

TSundar
Regular Visitor

Thank you so match, your solution is working for me and it's really valuable 

CNT
Community Champion
Community Champion

@TSundar Glad to help!

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,968)