How can I insert selected Listbox items as a new record in to a common data service table

0
votes

I have a PowerApps canvas App and I have a requirement of creating new records for all selected listbox items in to a table. I am acually trying to implement a many to many relationship scenario

my Listbox name is: ListBox1 and my table name is ContactsTable inside the page I have put a button and on click of button I put the following PowerApps logic:

ForAll(
    ListBox1.SelectedItems,
    Patch(
        ContactsTable,
        Defaults(ContactsTable),
        { EmpID: 2, Name: ListBox1.Selected.Name }));

it creates the last selected item repeated based on the number of items i select from listbox any Idea would be great.

1
powerappspowerapps-canvaspowerapps-formulacommon-data-service

1 Answers

1
votes

When specifying the Name property of the record that you are inserting into the Contacts table, you need to use the record that is being iterated in the ForAll - using the ThisRecord qualifier is a good way to do that:

ForAll(
    ListBox1.SelectedItems,
    Patch(
        ContactsTable,
        Defaults(ContactsTable),
        { EmpID: 2, Name: ThisRecord.Name }));

Technically you don't even need the ThisRecord (i.e., Name should be in scope), but I find that using it make it clearer.