Answered

Word Counting (regex) in PowerAutomate

(0) Share

Report

Posted on by BrokenClock431

Context :
User input is marked as draft in the associate powerapps until it meets a certain wordcount.

Flow should send out an email reminder to users who's textbox doesn't match the wordcount.

Powerapp formula:

CountRows(
 Filter(
 MatchAll(
 ThisItem.'Peer comment',
 "(\s|\n?)*(\s|\n?)"
 ),
 !IsBlank(FullMatch)
 )
 )

I'd like to count the wordcount the same way in my flow, to make sure the wordcount is consistent across both the app and the flow.

Issue is the functions I use in powerapps don't seem to exist in powerautomate.

I've seen I could use an excel spreadsheet to do the match,but that sounds overly complex.

Any suggestions ?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

grantjenkins 11,063 Moderator on at

Like (0)

Report
Copy link

Link copied!

There are some third-party connectors that offer regex. Otherwise, I'd suggest Office Script as you mentioned if you needed regex.

The only downside with using Office Scripts is that they are stored in your OneDrive. So, if other people need to use the script (flow runs as another user) you will need to share the Office Script first. We can now store Office Scripts in SharePoint, but unfortunately at this stage, you then can't access it from Power Automate - so needs to be in OneDrive for now.

Another alternative is to split the textbox content by " " which should give you an array of words and you can use length to get the number of items (words) in the array.

Was this reply helpful? Yes No
Verified answer

BrokenClock431 9 on at

Like (0)

Report
Copy link

Link copied!

I've gone plan B, and added a wordocunt column that the powerapps populates when submitting the form.

Not exactly great but hey.
Wish there was feature parity across the power ecosystem for different functions.

Was this reply helpful? Yes No