Equivalence percentage between two arrays.

[Ruben_Merino]

I am trying to compare the match percentage between a specific item with a list of items.

In both I have a column with the title and another with said title in array.

My idea is that it looks something like this

[BCBuizer]

Hi @Ruben_Merino ,

I hope the below will be enough to get you on your way, but you'll have to change some of the references to match what you are currently using:

Text(
	CountRows(
		Filter(
			ThisItem.Array,
			Value in DataRequest.Array
		)
	)
	/
	CountRows(
		DataRequest.Array
	)* 100
) & " % match"

[Ruben_Merino]

Hi @BCBuizer , 

First of all, thank you very much for replying so quickly. I created a global variable "onselect" in the arrow of "Data request" and when I try make your formula appear this text "This formula uses scope, which is not presently supported for evaluation".

I try to wrap with "Value" but dosen't work.

[BCBuizer · Accepted solution]

Hi @Ruben_Merino ,

The condition in the Filter seems to be causing the issue. Can you try this:

Text(
	CountRows(
		Filter(
			ThisItem.myArray;
			Value in _dataRequest
		)
	)
	/
	CountRows(
		_dataRequest
	)* 100
) & "%"

[Ruben_Merino]

Hi @BCBuizer 

I really appreciate all the help you are giving me.

I continue with the problem, I don't know if it could be because of how I have stored the data.

Attached image of the two Sharepoint lists.

• Dara request

• List of available data

[Ruben_Merino]

Hi @BCBuizer 

Finally!! 

Thanks a lot!! 

Text(
	CountRows(
		Filter(
			_wordsRequest;
            Find(Value(Result);ThisItem.Title)
		)
	)
	/
	CountRows(
		_wordsRequest
	)* 100
) & "%"