Help figuring out logic for an app that should be simple

[AngieH]

I'm trying to convert a difficult to use excel spreadsheet into a powerapp that can be edited directly. I'm using Sharepoint Lists for data storage (we don't have access to premium 365 features)

The Lists will store

Contact Information (list with 365 Contacts)

Office Supporting (list of 12 offices, office title doesn't change)

Service Offered (List of 5 services)

Backup/Primary Status (list of 10 different statuses (backup assistant, primary assistant, backup specialist, primary specialist, etc.)

The challenge is each person on the contact list can support multiple offices, provide multiple services, and have backup or primary depending on which office they are supporting.

I'm stuck trying to figure out how to link so many different variables.

Does anyone have a similar type of data set they've worked with that could help with ideas?

One idea I had is to build the separate lists and then create a flow to create a "master" list that can then be filtered, sorted, searched in a powerapp.

[TheRobRush · Accepted solution]

You can do all of this on a single SPList where each row is a separate contact, and the different options (office column, service column, status column) are just choice columns. there's no need to have separate lists, unless you just like that aesthetically.

[AngieH]

Thank you for your input.

Each person would have multiple offices/services/statuses, creating a list with about 200 entries.

I guess the point would be that powerapps would make it visually more manageable...

[TheRobRush]

Yes, I understood that each person would have multiple things assigned to them in each category. One SPList, with only the number of entries in it as number of people you have, can store all this information using the choice column. See my example image. I use a setup like this to manage a workorder request setup where several areas have several sub areas etc they can choose from.

You can then further break this down (IE Different jobs / statuses per person per office) with a second list

In image below once the client has chosen one area from list above in powerapps, their next gallery of options will be based off of the following list which gives different options depending on what was chosen in first list