Showing results for 
Search instead for 
Did you mean: 
Helper V
Helper V

how can remove/validate TextBox for Pre,Post-commas and consecutive comma/dots in TextBox

Hi Mates,

we have text-box, As per the requirement user should not enter per-commas before number in text-box means like below

1. Users can enter 90,8.5 but not ,90, here comma should remove automatically if they enter like Pre-Post Comms.

2. Consecutive comma/dots: users should not enter ,, or .. before or after or even in between also

ex: ,,12,15,, or ,,12,15.. or ..12,,15,, etc   Means users can enter Single/One Time Dot (.) or Comma between the Numbers but not before and after.

As of now i am using below formula on Text-box, On-change property, but this is allowing consecutive commas and dots.



How can i meet the above two requirements in text-box control.

 Highly appreciated if some one can help here. 


Helpful resources

Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,523)