cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper III
Helper III

Form with fileds populated by independent data

I'm trying to create a tool where users can utilize a variety of inputs that are independent of each other. For example.

 

Product combo box (12 items)

Campaign Name combo box (102 items)

Source combo box (20 items)

 

Right now I am simply dropping combo boxes on a canvas and creating a datasource for each one but I am not sure if this is the right way to do this or should all of this data be in a single datasource in their own columns? My experience with databases says they need to remain separate data sources since a row in a table is a record where all items are dependent.

 

Now, the output will go to a single datasource but am I going about building the input the right way?

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User III
Super User III

@Future_Vision 

In general this is not a bad approach.  It really depends on the amount of data that you will deal with in the list and what additional relationships you need from it.

For example, if the Campaign Name will potentially be filtered by what is in the Product, then having a relationship from Product to Campaign will be needed.  This can easily be done in a single list, but if not, then your Campaign list will need to have another column for the Product so you can filter on this later. That is relatively simple.

If you do it all in a single list, then you can utilize functions like GroupBy to get the relationship.

 

So, to answer your question...yes it is good, but it depends on where you are going with it all ultimately.

 

I hope this is helpful for you.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!

View solution in original post

3 REPLIES 3
Super User III
Super User III

@Future_Vision 

In general this is not a bad approach.  It really depends on the amount of data that you will deal with in the list and what additional relationships you need from it.

For example, if the Campaign Name will potentially be filtered by what is in the Product, then having a relationship from Product to Campaign will be needed.  This can easily be done in a single list, but if not, then your Campaign list will need to have another column for the Product so you can filter on this later. That is relatively simple.

If you do it all in a single list, then you can utilize functions like GroupBy to get the relationship.

 

So, to answer your question...yes it is good, but it depends on where you are going with it all ultimately.

 

I hope this is helpful for you.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!

View solution in original post

Helper III
Helper III

There really aren't any dependencies that I can think of. At least not on the input side other than un-hiding certain fields if a value, or a specific value, is entered in another field. For example, the Source dropdown. If the source is '3rd Party" then a text field is displayed to enter the name of the third party. That is about as complicated as it gets.

 

As for size of lists I think Brand is the biggest list although Products could eventually be as big. We're talking maybe 300-400 records

Super User III
Super User III

@Future_Vision 

Yeah, so if there is not much more complexity than that, your approach is fine.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!

Helpful resources

Announcements
secondImage

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

Top Kudoed Authors
Users online (81,012)