Create new list based on combobox in power app

(0) Share

Report

Posted on by Karolina776

133

Hello,

I have to create an app which users can enter new project and choose what product will be affected in.

After chasing products( it can be one or more ) I need to create another list where my products will be as separate rows in table, is that possible ?

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Building with Why 351 Moderator on at

Like (0)

Report
Copy link

Link copied!

Yes, in the app, make each Product entry a row in a gallery. Then when you create the records you will create a parent/child relationship between the project and the product. What is your data source?

Was this reply helpful? Yes No
Karolina776 133 on at

Like (0)

Report
Copy link

Link copied!

@DreamCatcher as a data source I use SP list now. TO be honest I do not have an experience with another data sources

Was this reply helpful? Yes No
Building with Why 351 Moderator on at

Like (1)

Report
Copy link

Link copied!

SharePoint is not really designed to be a database. HOWEVER, there are work arounds you can use to make this work. You will need 2 tables.

Table 1 Is the Parent. This will be for the Project.

Table 2 is the Child and will be for the Products.

When you set up Table 2 include a column to reference Project table. You can use a Lookup column or a text column. I used Text columns and it worked just fine. If you use a Text field you will have to keep the relationship yourself, while a Lookup will hold the relationship.

You can see in the screenshots below I used a unique key I created in the app to relate the tables and populated the Title column with this information.

Was this reply helpful? Yes No
Building with Why 351 Moderator on at

Like (0)

Report
Copy link

Link copied!

Here is the Patch statements I used:

ForAll(colPics,Patch('All-ENHA-Report-Records',Defaults('All-ENHA-Report-Records'), {

Title: Title,

JobNumber: JobNumber,

JobName: JobName,

RowNo: RowNo,

Photo:Photo

}));

ForAll(Filter(colPics, ID=1),Patch('All-ENHA-Report-Key', Defaults('All-ENHA-Report-Key'), {

Title: Title,

JobNumber:JobNumber,

JobName:JobName,

ProjectName:textJobDescription.Text,

Date:Text(datepickerPVF.SelectedDate, "yyyy-mm-dd"),

InternalNotes: textInternalMessage.Text

}));

Was this reply helpful? Yes No
Karolina776 133 on at

Like (0)

Report
Copy link

Link copied!

@DreamCatcher "colPics" in your formula is the collection based on combobox ? I think I need more step-by step tutorial to understand all steps correctly, for know I do not understand how I can do it for every choice from combobox.

Was this reply helpful? Yes No
Suggested answer

Building with Why 351 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Karolina776

yes, colpics holds the collection of the children.

Step 1: Create the record for the Project (Parent)

Step 2: select the products in the Products (Child)

Step 3: Press Save button

You can save the Parent at the end of Step 1 or during Step 3, as long as the Key is available.

Set(Key, Now()& "Project Name");

ClearCollect(colProducts, ComboBox1.SelectedItems);

ForAll(colProducts, Patch(SharePointList2, Defaults(SharePointList2), {

Title: Key,

Product: ThisRecord.ProductName

})

Was this reply helpful? Yes No