Unanswered

N Projects linked to N tests each

(0) Share

Report

Posted on by GuillaumeL

Hello everyone, I am blocking since few days on how to build one functionality of my application and I don't find a working solution on the community. Let me explain :

I started my application on a basic model Gallery, Display, Edit screens. I have a table PROJECTS (Id, Name, etc) that I can display with my gallery, see the information with my display form and edit with my edit form.

Now, I need to assign to each project a list of tests from a catalog. So I have a table CATALOG (Id, Name, Category). After the creation of a project, the user has to be able to select some tests from the catalog and save this list. At any time, another user accessing the project should be able to see this list and then fill each test with a value.

I don't know if I am clear but here is an example :

Table PROJECTS :
- Id 1, Project 1, ...
- Id 2, Project 2, ...
Table CATALOG :
- Id A, Test A, Category Visual
- Id B, Test B, Category Mechanical
- Id C, Test C, Category Mechanical
- Id D, Test D, Category Electrical

Now, I want to edit my projects like that :

Project 1 -> Test A, Test C, Test D
Project 2 -> Test B, Test C

And during the last phase, I will select my project 1, and for each test, I will define a value to the Project1.TestA, ...

I first though about a gallery displaying the test catalog and a table TESTS (Id, ProjectID, TestID, Value). It seems that we cannot use checkboxes in a gallery as I am not able to change the value but this is the idea. When I select the test in the catalog, it creates a row in the table TESTS, and delete it if I unselect the test.

Do you think it is the right idea ? Should I use a list to display the test catalog ? Or maybe a table ? To be able to display the category and the name of each test ?

Thank you for your help and sorry for the long message

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@GuillaumeL,
This sounds to me like a problem in database design. You are describing a many to many relationship ie each project can have many tests and each test can have many projects. The solution Invoves creating a junction table. there is an excellent discussion of how to do this in Powerapps http://baizini-it.com/blog/index.php/2017/10/10/powerapps-101-many-to-many-relationships-between-tables/ by @Meneghino.
GuillaumeL 15 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Drrickryp, thank you for your quick answer.

Yes this is exactly the structure I am building. To compare with their solution, I will use their table Products as my TestsCatalog, their table Orders as my Projects and their table OrderLines as my TestsLines.

For the architecture of the data, I think I am ok on it. But what I cannot succeed for now is how to link those data on my screens. For example, during the phase to select the products of the orders (in their example), how should I display it ? As a gallery with checkboxes ? It doesn't work for me, I cannot change the value of the checkbox when I run the application on my gallery.

I don't understand why Gallery and Controls doesn't work together ? Even with a text area for each item of the gallery, I cannot write anything ? Because I will need it to add the quantity of a product I need (In their example)

I think, I am just not understanding well how the objects interact together in PowerApps