Showing results for 
Search instead for 
Did you mean: 
Helper IV
Helper IV

Matching Algorithm in PowerApps? Is it Possible?

Hi all. 

I am required to do a matching algorithm where I need to check the compatibility rate between 2 people. Therefore, the compatibility rate would be dynamic. For example, the compatibility rate for A&B is 75%, but the compatibility rate for A&C is 45%. 

If I use SharePoint as my database, is it possible to do the Matching Algorithm in Power Apps? Any ideas & recommendations would help me a lot!



Super User III
Super User III

Hi @_kikilalaaa 

Are you able to define as a mathematical expression, how you would derive your compatibility rate percentage value between the two people? If the answer is yes, you would most likely be able to write a formula to calculate this.

Community Support
Community Support

Hi @_kikilalaaa ,


Could you please share more details about Matching algorithm in scenario to show us how to calculate the compatibility rate?

Based on what you've described, it's possible to do this, with the ForAll function to implement loops, and with collections and some aggregation functions to calculate the compatibility rates, but we need more detail to provide detailed solution.



Helpful resources

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.


Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (10,963)