Return total number of a given character/string from another string

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I cannot find a way to do this, and it seems so simple!

Eg, find number of 's' in 'snakes' or '.' in "www.hotmail.com"

Apologies if this has been asked elsewhere, but I can't find anything after lengthy searching.

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Sort by

Verified answer

timl 37,283 Super User 2026 Season 2 on at

Like
a
(5)

Report
Copy link

Link copied!
Hi @Anonymous

You can call the MatchAll function to search for a character in string. MatchAll returns a table for all matches that are found. The CountRows function will then provide a count of results like so:

CountRows(MatchAll("snakes", "s"))

Note that the MatchAll function accepts a search pattern in the form of a regular expression. The period symbol is a special character so in your hotmail example, you would need to escape this with a \ symbol.

CountRows(MatchAll("www.hotmail.com", "\."))

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @Anonymous ,

Do you want to calculate the total number of a given character/string within another string?

Based on the needs that you mentioned, I think the MatchAll function could achieve your needs. I have made a test on my side, please take a try with the following workaround:

Add a Label in your app, set the Text property to following:

CountRows(MatchAll("snakes", "s", MatchOptions.Contains))

CountRows(MatchAll("www.hotmail.com", "\.", MatchOptions.Contains))

Please consider take a try with above solution, check if the issue is solved.

More details about the MatchAll function, please check the following article:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-ismatch

Best regards,

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
<quote>
Hi @MaxDonen
You can call the MatchAll function to search for a character in string. MatchAll returns a table for all matches that are found. The CountRows function will then provide a count of results like so:
CountRows(MatchAll("snakes", "s"))
Note that the MatchAll function accepts a search pattern in the form of a regular expression. The period symbol is a special character so in your hotmail example, you would need to escape this with a \ symbol.
CountRows(MatchAll("www.hotmail.com", "\."))

</quote>
Brilliant-exactly what I was looking for. Thank you.

Was this reply helpful? Yes No