topic Re: Matching Algorithm in PowerApps? Is it Possible? in Building Power Apps
https://powerusers.microsoft.com/t5/Building-Power-Apps/Matching-Algorithm-in-PowerApps-Is-it-Possible/m-p/727968#M232998
<P>Hi <LI-USER uid="107093"></LI-USER> </P>
<P>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.</P>Sat, 24 Oct 2020 10:35:30 GMTtiml2020-10-24T10:35:30ZMatching Algorithm in PowerApps? Is it Possible?
https://powerusers.microsoft.com/t5/Building-Power-Apps/Matching-Algorithm-in-PowerApps-Is-it-Possible/m-p/727801#M232966
<P>Hi all. </P><P>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%. </P><P>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!</P><P> </P><P>THANK YOU!</P>Sat, 24 Oct 2020 04:10:26 GMThttps://powerusers.microsoft.com/t5/Building-Power-Apps/Matching-Algorithm-in-PowerApps-Is-it-Possible/m-p/727801#M232966_kikilalaaa2020-10-24T04:10:26ZRe: Matching Algorithm in PowerApps? Is it Possible?
https://powerusers.microsoft.com/t5/Building-Power-Apps/Matching-Algorithm-in-PowerApps-Is-it-Possible/m-p/727968#M232998
<P>Hi <LI-USER uid="107093"></LI-USER> </P>
<P>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.</P>Sat, 24 Oct 2020 10:35:30 GMThttps://powerusers.microsoft.com/t5/Building-Power-Apps/Matching-Algorithm-in-PowerApps-Is-it-Possible/m-p/727968#M232998timl2020-10-24T10:35:30ZRe: Matching Algorithm in PowerApps? Is it Possible?
https://powerusers.microsoft.com/t5/Building-Power-Apps/Matching-Algorithm-in-PowerApps-Is-it-Possible/m-p/728673#M233245
<P>Hi <LI-USER uid="107093"></LI-USER> ,</P>
<P> </P>
<P>Could you please share more details about Matching algorithm in scenario to show us how to calculate the <SPAN>compatibility rate?</SPAN></P>
<P><SPAN>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.</SPAN></P>
<P> </P>
<P><SPAN>Sik</SPAN></P>Mon, 26 Oct 2020 06:47:55 GMThttps://powerusers.microsoft.com/t5/Building-Power-Apps/Matching-Algorithm-in-PowerApps-Is-it-Possible/m-p/728673#M233245v-siky-msft2020-10-26T06:47:55ZRe: Matching Algorithm in PowerApps? Is it Possible?
https://powerusers.microsoft.com/t5/Building-Power-Apps/Matching-Algorithm-in-PowerApps-Is-it-Possible/m-p/802428#M256068
<P><LI-USER uid="86221"></LI-USER> <LI-USER uid="6096"></LI-USER> i have just able to come out with the scenario.</P><P> </P><P>Table below shows data for 3 students. Each student is ranked from 1 to 3 based on certain attribute.</P><P> </P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="_kikilalaaa_0-1611305391177.png" style="width: 400px;"><img src="https://powerusers.microsoft.com/t5/image/serverpage/image-id/215697iEA90965C8E5EF386/image-size/medium?v=1.0&px=400" role="button" title="_kikilalaaa_0-1611305391177.png" alt="_kikilalaaa_0-1611305391177.png" /></span></P><P> </P><P>I want to calculate the compatibility rate between the students based on the marks in the column attribute. Basically Student A will be compared with Student B and C, Student B will be compared with Student A and C, Student C will be compared with student A and B. </P><P> </P><P>The formula is as follow: </P><P>for each student, stud, in database<BR />attrib1_diff = curr_stud_attrib.attrib1 - stud.attrib1<BR />attrib2_diff = curr_stud_attrib.attrib2 - stud.attrib2<BR />...<BR />attrib5_diff = curr_stud_attrib.attrib5 - stud.attrib5</P><P> </P><P><BR />incompatibility rate= sqrt( attrib1_diff*attrib1_diff + attrib2_diff*attrib2_diff + ... + attrib5_diff*attrib5_diff)</P><P> </P><P>The incompatibility rate will then be stored in new column in the sharepoint list.</P><P> </P><P>As you can see, this requires looping. Any idea how to do this in Power Apps?</P>Fri, 22 Jan 2021 09:07:51 GMThttps://powerusers.microsoft.com/t5/Building-Power-Apps/Matching-Algorithm-in-PowerApps-Is-it-Possible/m-p/802428#M256068_kikilalaaa2021-01-22T09:07:51Z