Word Count in a Field

[Rozz]

Hello all, 

I have set up an MS Form that drops information into a MS List. 

I need to count the number of characters (text, spaces, puntation etc) in each cell within a specific column and when the word count exceeds a 1000, i will trigger an automatic email to the submitter to let them know they need to revise and resubmit. 

I am OK with triggering an email, but i can not identify how to get Power Automate to calculate the word count in the cell. 

Any advice would be greatly appreciated (if possible, please include screen shots, as I am not very good at following written steps)

MANY THANKS

Rozz

[Sundeep_Malik]

Hey @Rozz 

I got a little confused that you want number of words or number of characters.

So, I did both for you. Firstly somehow you will have to convert the cell to a string, as it might be coming in as an array.

Then do this:

The above compose has a test sentence.

Now to calculate number of characters, you can use the length function.

Expression used above: length('Compose_2')

After that if you want to calculate number of words. Do this:

To count number of words do something like this:

Expression:

sub(length(split(outputs('Compose_2'),' ')),1)

So, I am first splitting at each space, then taking out its length. And then subtracting one.

As the count of above was coming 8. Actually it made an extra element at the end so used sub function.

Final output:

You might have to subtract one for number of characters as well, as just now I counted it is 37, it must be adding last space to, which you dont have to count.

[Rozz]

Good morning, thank you for your help. I need to count characters in a specific field in either the orginal MS Form question or in the MS List it is transferred to. Therefore I need the count to be driven by a specific field and i want the character count to drop into another column in the MS List. 

Your compose box has a test string of characters and not a link to a field, would you be able to help with this. 

Many thanks

[rishabhkhanna1]

You can use power automate bot that gets triggered whenever a new response is submitted through MS Forms.

Below trigger and action for your reference.

Next, you can add a Compose action to check the length of the characters used for that specific section.

Further , you can check a condition to check if that length crosses 1000, then you notify the user who submitted their response using 'Send an email (v2)' action , else let it go ahead and create the entry in MS list as desired.

Hope this helps.

[Sundeep_Malik]

@Rozz 

I have used a test string, instead just pass one of your dynamic field in the compose. Add all your dynamic fields in different composes. And then just use the length function to calculate the number of characters. There will be an easier way to do it with just one compose. But just do the above process for now. If you are able to do it, we can go further with the difficult one.