cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ruben_Merino
Frequent Visitor

Equivalence percentage between two arrays.

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

 

Ruben_Merino_0-1665735704907.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
BCBuizer
Super User
Super User

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
) & "%"

 



Did you like my post? Please give it a thumbs up! Did I resolve your issue? Please click Accept as Solution to close the topic and so other members of the community can find solutions more easily.

View solution in original post

5 REPLIES 5
BCBuizer
Super User
Super User

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"

 



Did you like my post? Please give it a thumbs up! Did I resolve your issue? Please click Accept as Solution to close the topic and so other members of the community can find solutions more easily.

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.

Ruben_Merino_0-1665745936517.png

 

Ruben_Merino_1-1665746003945.png

 

BCBuizer
Super User
Super User

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
) & "%"

 



Did you like my post? Please give it a thumbs up! Did I resolve your issue? Please click Accept as Solution to close the topic and so other members of the community can find solutions more easily.

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

 

Ruben_Merino_0-1665991930220.png

 

  • List of available data

 

Ruben_Merino_3-1665992111199.png

 

 

 

Ruben_Merino
Frequent Visitor

Hi @BCBuizer 

Finally!! 

Thanks a lot!! 

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

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,106)