Unanswered

Looking for assistance on saving multiple records with two different controls

(0) Share

Report

Posted on by jpwintz

I am just starting out with PowerApps (i.e., about 2 weeks) and am trying to do a proof of concept where I can select a single value from a list and multiple values from a list, gallery, combobox, etc. and save multiple records (i.e., not concatenate) to the dataverse table. I have started looking at PowerApps 911 tutorials and have started understanding the collection and patch features. So far I am able to patch a single selection from both controls but not a single selection from one and multiple from the other as intended.

This YouTube video captures what I am trying to do, but I have not figured out where he is starting from in order to execute what he is demonstrating: PowerApps use Collect to submit multiple rows of data to your data source - YouTube

Thanks for any help you can provide on getting me started!

Categories:

Building Power Apps

I have the same question (0)

All responses (50)

Answers (0)

Sort by

turnerj3 2,039 on at

Like
a
(0)

Report
Copy link

Link copied!

@jpwintz ,
In order to Patch multiple you would need to use a ForAll.
From a gallery you could use this to send gallery items to a collection
ForAll(Gallery1.AllItems,Collect(col1,{Column1:'Created By'.DisplayName,Column2:Textbox1.Text}))
This would create new list items with a patch:
ForAll(Gallery2.AllItems,Patch(SPList,Defaults(SPList){Title:YourData,ListColumn1:'Created By'.DisplayName,ListColumn2:File}))

You could do similiar by Collecting all the data first then Patching the collection to a list.

I hope this helps.

Was this reply helpful? Yes No
jpwintz 63 on at

Like
a
(0)

Report
Copy link

Link copied!

I am tracking on the ForAll and Patch. In my setup, I have 3 tables. Two are lookup tables and one is the merge/join table that records the results. I want to be able to select a single item from one table (gallery, listbox, etc) and multiple items from another table and save the dataset to the third table for each of the multiple selections involved.

Was this reply helpful? Yes No
turnerj3 2,039 on at

Like
a
(0)

Report
Copy link

Link copied!

Will each item that you want to select go in a specific column in the 3rd table?

Was this reply helpful? Yes No
jpwintz 63 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes - I have attached a screen shot to kind of show what I am doing. The two tables on the far right (A and B) are my two lookup tables). I am picking one A value and multiple B values. They should save to a corresponding row in the join table on the far left of the screen.

Was this reply helpful? Yes No
turnerj3 2,039 on at

Like
a
(0)

Report
Copy link

Link copied!

In this example you are wanting to create 3 new rows containing
black/artistic
black/cool
black/dark?
or one record like black/artistic, cool, dark?

Was this reply helpful? Yes No
jpwintz 63 on at

Like
a
(0)

Report
Copy link

Link copied!

I want three records:
black/artistic
black/cool
black/dark

Was this reply helpful? Yes No
turnerj3 2,039 on at

Like
a
(0)

Report
Copy link

Link copied!

@jpwintz ,
Here is an example. I created a collection from combobox with types from a table for your 3rd table. A data table where I selected the color record like your 2nd table and then patched to my first table.

ClearCollect(col7,ComboBox3.SelectedItems);
ForAll(col7, Patch(Photos,Defaults(Photos),{Title:1,Url:DataTable1_1.Selected.color ,Figure:ThisRecord.type}))

col7 is my collection. Photos is my list, your table. You will need to change to your columns and your selections.

Was this reply helpful? Yes No
jpwintz 63 on at

Like
a
(0)

Report
Copy link

Link copied!

PowerApps is not liking how I have had to adapt your formula for my tables:
ClearCollect(col7,lstB.SelectedItems);
ForAll(col7, Patch('JPW JoinABS', Defaults('JPW JoinABS'), {A: lstA.Selected.'ID-A', B: 'ID-B'}))

lstA is a single select listbox that includes the color names. The columns are ID-A and Color Name.
lstB is a multi select listbox that includes the color types. The columns are ID-B and Color Type
The Join Table has an autogenerated ID and columns A and B which are linked to the lD values above and translated to the visible name.

Was this reply helpful? Yes No
turnerj3 2,039 on at

Like
a
(0)

Report
Copy link

Link copied!

What error is it giving for this?

Was this reply helpful? Yes No
jpwintz 63 on at

Like
a
(0)

Report
Copy link

Link copied!

Attached are my errors and the red line under the code

Was this reply helpful? Yes No