Answered

Using toggle to change different columns

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello everyone!

I am building a relational database where I want the user to determine who is a business partner of who and save such info on a sharepoint lists. As an example:

There are Companies A, B, C and D.

* A can trade with B, C and D

* B can trade with A, and D but not C

I was thinking of using a toggle to make it simpler for each user to select which company it can trade with and the end result would be something like the image below.

The table itself is a bit more complex and the best way I thought was to create 1 column for each company and an indication of Yes/No. An example is below:

I manage for the toggle to understand the Yes and No's based on an If statement:

ThisItem.Company in Sort( Distinct( Filter(Business_Partners, If( Dropdown.Selected.Result = "Company A", 'Company A' = "Yes", "Company B", 'Company B' = "Yes", "Company C", 'Company C' = "Yes", "Company D", 'Company D' = "Yes")), Entity),Result)

My problem is: How do I patch if user decides that Company B can trade with C? My goal is for the googgle to change the Yes/No values in such sharepoint list.

Any suggestions? It can even be a completely different approach to the problem, script and Sharepoint.

Thank you in advance!

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

GarethPrisk 2,828 on at

Like
a
(1)

Report
Copy link

Link copied!
As you are encountering, having your data model use columns for explicit Companies is going to become unwieldy and unmanageable long-term.

Instead, refactor your data to simply be a relationship pairing.

Primary Company

Secondary Company

Can Trade?

This way, you'll have a list of records that defines the behavior. You'll have to ensure your data is accurate, but it's data versus adding columns and having to manually update the app each time.

I'd also have a list that defines the Companies, if you don't already.

Then your drop-down shows the list of Companies.

Your Gallery shows a filtered list where that Company is the Primary or Secondary. The row would dynamically show the side which isn't that Company, and show the Can Trade? value.

This way, it's a single record to maintain and it accurately reflects the behavior from the perspective of either Company.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I get your point. Basically transposed each column into a new set of 1:n companies and repeat it for each "origin" company. There are some changes I had to do to output the data for the next step of the process but indeed this solved my problem.

Thanks @GarethPrisk !