cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
StealthTalon
New Member

Customer needs app to capture and report golf statistics on players

I have a customer that is asking to build a Power App that can capture golf player scores from different golf courses, then present back statistical analysis of the individual and teams.

 

What would be the best options to build something like this?

1 ACCEPTED SOLUTION

Accepted Solutions
GarethPrisk
Resident Rockstar
Resident Rockstar

I would get a trial license and environment and give it a go. 😁

I wouldn't worry too much about security and access for the proof of concept. More of a focus on a data model, and the app for data entry.

  • Get a Dataverse environment
  • Use/Add a few Tables, and relate them
    • Contacts (an out of the box table) could be used for the Golfer(s) - or create your own
      • Add metadata you want (Handicap, Years of Experience, etc.)
    • Accounts (an out of the box table) could be used for the Golf Course(s) - or create your own
      • Add metadata you want (Par, Length, etc.)
    • Create Golf Team(s) table (there's a Team table out of box, but this is for security mostly, make your own)
    • Create Golf Team Member(s) table
      • This is effectively an intersect table
      • Let's your relate N:N (Golfer : Golf Team)
    • Create Golf Round
      • Add relationships to the other tables as Lookups (N:1)
        • Golfer
        • Golf Team
        • Golf Course
      • Add metadata about the Round
        • Date
        • Score
        • Etc.
  • Configure the Forms for your tables
  • Create a model-driven app
    • Add your tables
    • Save and Publish
  • Run and test the model-driven app

 

This will be the fasted way to a PoC "app" in your scenario. Given the limited users, and no immediate need for mobile - I would consider a model-driven app first. You can always add a Canvas app afterwards, but having the Tables, Relationships, and MDA are going to be required for a holistic experience anyways.

 

https://docs.microsoft.com/en-us/powerapps/maker/model-driven-apps/

 

There's a ton to dig into documentation wise, but that's the highest level to get you started.

I always like to draw out my data model in Visio, WhiteBoard, or even on paper first. Once you have a sense of how things are going to be stored and related, then you can build quickly and effectively. Then you just need to edit the Forms (to create a good data input experience), and then create and publish the app to allow you to quickly use and interact with the tables.

View solution in original post

3 REPLIES 3
GarethPrisk
Resident Rockstar
Resident Rockstar

In broad sense - yes - the Power Platform as a whole is a good fit for this.

  • You can create a data model in Dataverse to store the data
    • Players
    • Teams
    • Team Player (N:N)
    • Courses
    • Rounds
    • Etc.
  • You can create rich visual reports against the data using Power BI
  • You can integrate the data from various sources using Dataflows, Power Automate, etc.

 

The main questions should be:

  • Data Governance
    • Where is this data coming from?
    • Who is entering it?
    • Who owns it?
  • User Experience (UX)
    • If users are entering data, how will they do this?
    • If users are reviewing data, how will they do this?
    • What type of reports and analytics are you looking to get?
  • Security & Access
    • Are all users part of your organization? Any outside need access?
    • Do different users need different access to the data?

A quick list of simple questions to get you started in organizing your approach. Good luck!

Gareth -

I really appreciate the quick response. I think, for now, this is 1-2 users entering data (within the org) for about 20-30 players' data. For Proof of Concept, we can do Desktop tools, but it may make sense just to do a mobile UI. 

 

So, I'm a complete newb with this Power App thing. Can you give me a quick game plan so I can learn how to just build the dataset using Dataverse and the simple Input UX? 

 

I'm a pretty quick learner, but I'm a lifelong Security Network Engineer trying to build a small Power App. 😞

 

Thanks!

GarethPrisk
Resident Rockstar
Resident Rockstar

I would get a trial license and environment and give it a go. 😁

I wouldn't worry too much about security and access for the proof of concept. More of a focus on a data model, and the app for data entry.

  • Get a Dataverse environment
  • Use/Add a few Tables, and relate them
    • Contacts (an out of the box table) could be used for the Golfer(s) - or create your own
      • Add metadata you want (Handicap, Years of Experience, etc.)
    • Accounts (an out of the box table) could be used for the Golf Course(s) - or create your own
      • Add metadata you want (Par, Length, etc.)
    • Create Golf Team(s) table (there's a Team table out of box, but this is for security mostly, make your own)
    • Create Golf Team Member(s) table
      • This is effectively an intersect table
      • Let's your relate N:N (Golfer : Golf Team)
    • Create Golf Round
      • Add relationships to the other tables as Lookups (N:1)
        • Golfer
        • Golf Team
        • Golf Course
      • Add metadata about the Round
        • Date
        • Score
        • Etc.
  • Configure the Forms for your tables
  • Create a model-driven app
    • Add your tables
    • Save and Publish
  • Run and test the model-driven app

 

This will be the fasted way to a PoC "app" in your scenario. Given the limited users, and no immediate need for mobile - I would consider a model-driven app first. You can always add a Canvas app afterwards, but having the Tables, Relationships, and MDA are going to be required for a holistic experience anyways.

 

https://docs.microsoft.com/en-us/powerapps/maker/model-driven-apps/

 

There's a ton to dig into documentation wise, but that's the highest level to get you started.

I always like to draw out my data model in Visio, WhiteBoard, or even on paper first. Once you have a sense of how things are going to be stored and related, then you can build quickly and effectively. Then you just need to edit the Forms (to create a good data input experience), and then create and publish the app to allow you to quickly use and interact with the tables.

View solution in original post

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,370)