Unanswered

Need help with figuring out a leader board

(0) Share

Report

Posted on by marine72781

Good evening all you smart folks. Please bare with me as I am a first time poster and want to lay everything out for you all in hopes that you can help me. I am working on my company's Sharepoint site and trying to do a little more than I believe I know how.

The event is a walk-a-thon. The SharePoint page has a microsoft form connected to it. The form takes in the input of 3 items
1) time walked

2) steps taken

3) miles walked

Once the form is submitted a flow starts that creates an item on a sharepoint list (found a video on this). The form allows a person to submit multiple times and the flow works as intended.

The Sharepoint list has the following columns:

1) Submitter's name

2) time walked

3) steps taken

4) miles walked

What I am trying to do is create some kind of leader board. I want a leader board for each of the inputs but I am having a hard time how to add up "like names". For ease lets just focus on time walked. So say I submit 3 days in a row; I want my total cumulative time walked number to be able to get figuredout. I'm just not sure how to set this up. I was thinking I possibly needed to create a separate sharepoint list that somehow takes in the a name and the time walked, when the same name comes in again it adds the new amount to the old amount and deletes the old entry?

Any help would be greatly appreciated

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Brad_Groux 4,556 on at

Like (1)

Report
You are on the right track of how I would do it, just think of your SharePoint lists as tables in a database. You have your "submission" table, and your "user" table, and the user table tracks all of the trends and goals for that user.

Then, you could have a "leaderboard" table, to take the best of the user data, and post it to the leaderboard. For comparing results in the leaderboard, and/or knowing when to delete a user's entry as they are passed by another user, you'd simply Add a condition to a flow.

Further:

Understand data operations - Power Automate | Microsoft Docs

Use expressions with conditions. - Power Automate | Microsoft Docs

Reference guide for functions in expressions - Azure Logic Apps | Microsoft Docs

If you could provide an expanded screenshot of your Flow and steps, your Flow run history, and of any detailed error messages you're receiving we could likely better assist you. Also, for the best results, you may want to review How to write a good forum post.

If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION ☑️. If you find this reply helpful, please consider giving it a LIKE. Want to know more? Follow @BradGroux on Twitter, and check out my Medium blog at https://msft.engineer.

Was this reply helpful? Yes No
Verified answer

bibhupanigrahi 240 on at

Like (1)

Report
Hi @marine72781, maintaining one list for unique users and their total scores and another for current data for each submission is a good idea. For simplicity (since you already have the current data for each submission as Forms responses), you could add up the current data submitted for a user via Forms to the existing data for that unique user in SharePoint list. For example, to always see the total miles walked for users in the SharePoint list, this is what I would do in flow:

Get the submitted form details on submission (trigger).
Get items of the SharePoint list using filter where the user matches the form submitter. Be careful, you would still get an array although the user exists in SP list just once. The array will have one item, which you will need to extract using array[0].
Get the miles walked data (hopefully it is number column) of that item.
Add it to the miles walked of the current form submission using add formula.
Save the new data back to the SharePoint item using an 'Update item' action.
You can follow similar logic for other fields. Hope this helps!

Was this reply helpful? Yes No
bibhupanigrahi 240 on at

Like (0)

Report

Hi @marine72781 , glad you liked my answer. If it helped you solve the problem, could you please mark it as an answer.

Was this reply helpful? Yes No