Hi @Jagadeeshk :
I've made a test for your reference:
- I assume There are two collections:
ClearCollect(
'Collection 1',
{'user list':"Mike"},
{'user list':"Lee"},
{'user list':"Lily"}
);
ClearCollect(
'Collection 2',
{'Machine_ID':"M1",Machine_Users:
Table({'user list':"User1"},{'user list':"User2"})
},
{'Machine_ID':"M2",Machine_Users:
Table({'user list':"User3"},{'user list':"User4"})
}
)
- I assume you want to update the record of Machine_ID="M2"
Step 1: Add a gallery(Gallery9) and set it's items property to
'Collection 1'
Step 2: Add a button and set it's OnSelelct property to:
ClearCollect(
UpdateList, /*UpdateList is my custom collection*/
LookUp('Collection 2',Machine_ID="M2").Machine_Users
);
Collect(
UpdateList,
Gallery9.Selected
);
Patch(
'Collection 2',
LookUp(
'Collection 2',
Machine_ID="M2"
),
{Machine_Users:UpdateList}
)
Best Regards,
Bof
