Power Platform Community Forum Thread Details

Help please!😩

i have a flow in which i have to match excel colum for each keywords, if excel colum contains that keyword then given count of total in new table.

my column look like this and let suppose keyword is HRS-ANZ

Categories:

General topics

@sgoyal696

I have made a test on my side using a test excel. Screenshot below:

I have used 2 variables, to initialize count and the keyword. You can even use dynamic value for the keyword, in this case I have used the same as you mentioned.

Then I'm reading the data from excel:

Then, I'm iterating through the rows and using expression, checking if the keyword exists in the column value.

expression:

contains(items('Apply_to_each')?['description'],variables('keyword'))

In the end, the count variable will have the total count where the keyword existed. Then you can store the value of the count in another table.

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.