rolling up score and ranking profiles

Like (0) Share

Report

Posted on 27 Dec 2023 07:11:09 by MohanadElsayed5

Hello all

I need your support to figure out what could be the best design for the following problem

I have 2 tables, profile and activities, profiles are assigned to groups and each profile can do some activities to get scores

the targeted solution is whenever there's a new activity for a specific profile submitted in the activity table then it adds up to the "TotalScore" in profile table and compare all profiles under the same group in Profile table then re-rank them

the issue is that if I create 1 big flow that do the 2 tasks -rolling up score and ranking- it'll be a mess, because the activity frequancy is little bit high, so re-ranking the profiles could be overlaped is 2 profiles submitted an activity on the same time

is there a better solution than one big flow for both tasks?

and how cold I do the re-ranking for profiles in flow?

my datasource is SP