Powerapps - Dynamically adding columns (Input Text Boxes) to a table

Question

I am trying to build a Power App that creates Input text boxes dynamically.

This is my data.

Category Name         Product 1       Product 2     Product 3  Product 4 
Marketing Center 1     1               1              2           2
Marketing Center 2     1               1              2           2
Marketing Center 3     1               1              2           2
Marketing Center 4     1               1              2           2
Marketing Center 5     1               1              2           2

Now, the Problem here is My Category Names and as well as Product columns increases over time.

How Can I build a User Input table dynamically to get the User Inputs - Something like this...and gives me the total of it...

Category Name         Product 1       Product 2     Product 3  Product 4   Total 
Marketing Center 1     1               1              2           2         6
Marketing Center 2     1               1              2           2         6
Marketing Center 3     1               1              2           2         6
Marketing Center 4     1               1              2           2         6
Marketing Center 5     1               1              2           2         6

The values of the Products are editable and the total gets calculated on the fly as the user inputs.

I believe this can be done with some data modelling and collection concepts. But I am new to this.

SeaDude · Accepted Answer · 2019-05-19 14:13:17Z

1

What is the Data Source? A SQL Table? A Sharepoint List? In-app data that user creates?

Somehow you need to get a Collection of the data (ex: colYourData). Once you have that, use the AddColumns and Sum functions to get the Total column.

Something like:

ClearCollect(colYourDataWithTotals, 
    AddColumns(colYourData,
        "Total",
        Sum(colYourData, product1, product2, product3, product4)
    )
)

edited May 19, 2019 at 14:13

answered May 17, 2019 at 7:18

SeaDude

4,4869 gold badges50 silver badges94 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Powerapps - Dynamically adding columns (Input Text Boxes) to a table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related