Skip to main content
Post a question

Notifications

Announcements

No record found.

Microsoft Dynamics 365 | Integration, Dataverse...
Answered

Sports club Solution building as a student project.

Like (0) ShareShare
ReportReport
Posted on 8 Dec 2021 17:36:33 by 52

Hello,

 

I’m a student in D365 and Power Apps, this a fulltime +1.000 hours training.

One of the goals is also to ask for support from the community, that’s why I’m reaching out via this medium.

 

We got a project case, where we have to build a solution starting a sport club.

 

This is a football club, where I use the account table as basis for the Teams of the ‘home club’ (and the competing teams).


Entities:

  • Account
  • Contact
  • League (U15, …, Senior)
  • Field position (goalkeeper, …)
  • Game Registration (where we relate the players to a certain game)
  • Game
    • Game registration ID (with a power automate flow: Date – home team – visiting team)
    • Home Team
    • Visiting Team
    • Start date and time
    • Score Home
    • Score Visitors
    • League
    • Home Game (Boolean, slider on form?)
    • Result (lost, draw, won,…)

  

Now one of the advanced optional things we have to think of is the following.

  1. It would be great if the coach could enter a the player who scored (and the time in minutes) on his mobile.
    Obviously this needs to be done with a new entity and with a canvas app.
    The goal would be that the Score is automatically updated in the Game entity.
    So the player is linked (via Game Registration entity) to a team for that match.
    E.g. Player x scores in minute 23 -> Score of his team in Game entity -> +1
    This is only done for the home teams (different ages and gender teams).
    For the opposing teams, we only track the name (account entity) not the players.
  2. Another extra would be to that the result (lost, dran, won…) is automatically updated with the score. This has to keep into account with which team is the home team, of course.
    Seems that an extend business rule is the way to go, or a Power Automate Flow?

For this I would like some suggestions, ideas, sparring partners, …

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on 09 Dec 2021 at 07:54:18
    RE: Sports club Solution building as a student project.

    Hi SergeP,

    1.When you create an app, or someone shares an app with you—either a canvas app or model-driven app—you can run that app on iOS and Android devices by using Power Apps mobile.

    Run canvas app and model-driven apps on Power Apps mobile - Power Apps | Microsoft Docs

    2.You can try to use Rollup field to aggregate team scores,  A rollup field contains an aggregate value computed over the records related to a specified record

    Create rollup fields in Dynamics 365 Customer Engagement (on-premises) | Microsoft Docs

    3.You can update results automatically through business rule, workflow, power automate or js based on your specific needs.

    Aggregated Intelligence: Dynamics CRM–Business Rules or Workflows?

    Microsoft Flow vs Microsoft Dynamics CRM Workflow - Microsoft Dynamics CRM Community

    https://www.google.com.hk/url?sa=t&rct=j&q=&esrc=s&source=web&cd=&cad=rja&uact=8&ved=2ahUKEwi9oKP0ndb0AhVLSWwGHW6HDBcQwqsBegQIMRAB&url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DlzzOqTyb74U&usg=AOvVaw02wrhoa0LRLRDGdALzDBPo 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,759 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,468 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans
Loading started