Answered

Form with fileds populated by independent data

(0) Share

Report

Posted on by Future_Vision

634

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@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.

Was this reply helpful? Yes No
Future_Vision 634 on at

Like (0)

Report

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

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (1)

Report

@Future_Vision

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

Was this reply helpful? Yes No