Patching Multiple Records to Dataverse Lookup Field

[Powerappsdev2]

Dear Team,

I created  canvas app.datasouces are projects,users,Resouces.

Gallery items=projects.

Inside gallery.project name,Task name,price=textinput, combobox[multi-select]=items=users.

Input like below

galley rows like below

Project name=Abc ,task name=abc,Users=zennifer,Melon

Project name=Abc ,task name=xyz,Users=blank

Project name=Abc ,task name=efg,Users=sadvin,IT User

Project name=Abc ,task name=numbers,Users=blank.

Output like below

Projectname taskname  Users

Abc               abc           zennifer

Abc             xyz              zennifer

Abc            efg               zennifer

Abc          numbers        zennifer

Abc          abc               Melon

Abc         xyz                 Melon

Abc        efg                  Melon

Abc        numbers         Melon

Abc       abc                   sadvin

Abc       xyz                    sadvin

Abc        efg                   sadvin

Abc       numbers          sadvin

Abc        abc                 IT User

Abc       xyz                  IT User

Abc       efg                  IT User

Abc       numbers         IT User

Please help to achieve above requirement.

Thanks in advance for quick respond....!!

[Amik]

@Powerappsdev2 - one example:

ForAll(
    'Your Gallery'.AllItems As _item,
    Patch(
        'Your Dataverse Table',
        ForAll(
            _item.ComboBox1.SelectedItems As _selections,
            {
                'Project Name': _item.ID,
                'Task Name': _item.TextInput1.Text,
                Users: _selections
            }
        )
    )
)

Note the above assumes the Items property of the ComboBox control embedded into the Gallery control actually contains records, for example I would expect the Items property of the ComboBox control to contain:

Choices([@'Your Table'].Users)

[Powerappsdev2]

Hi @Amik ,

    Thanks for respond,

 Above code save the single row only,selected users to be save the entire rows in a gallery.

Ex

gallery contains 3rows only first row combox contains the users remaining combox  are blank then output to be first row selected users saved all 3 row values.

Gallery like below

Gallery items=projects,in gallery combobox=items=user

Project Name	Task Name	Hours price	User
Development	Training	100	IT User,Testing user
Development	KT
Development	Demo	150	IT USER

Records to be saved in User assignment table like below

User	ProjectName	TaskName	Hours price
IT User	Development	Training	100
IT User	Development	KT
IT User	Development	Demo
Testing user	Development	Training	100
Testing user	Development	KT
Testing user	Development	Demo
IT USER	Development	Training
IT USER	Development	KT
IT USER	Development	Demo	150

out put to be selected users to be saved in entire rows.

Please help to achieve my requirement.

Thanks in advance for quick respond.

[Amik]

@Powerappsdev2 - the code I gave you will create a new single row per the number of selected users for each row in your gallery.

As I now understand it, you want to create a new row per the number of selected users, and per the distinct number of task names.

Are you always going to have 3 task names you want to create duplicate rows for?

[jyotiatharv]

@Powerappsdev2  Tryout below code and modify as per your table and field names

ForAll(
    'Your Gallery'.AllItems As _item,
     ForAll(
            _item.ComboBox1.SelectedItems As _selections,
           Patch(
               'User Assignment',
                Defaults('User Assignment'),
                {
                'User': _selections
                'Project Name': _item.ID,
                'Task Name': _item.TextInput1.Text,
                'Hours price': _item.TextInput2.Text,
                }
        )
    
        
    )
)