How to get dropdown selection to check/uncheck the checkbox

[PDRC]

Hello everyone,

I have stuck on an issue
I have below tables with me in dataverse

In canvas I have to assign the document to particular employee
I have a dropdown connected to the shared Doc and from there I am getting all the documents in dropdown 
I have a gallery connected to the Employee , check + employe name

if I select any documnet from dropdown it should show that to whom it is assign in the gallery with check & if not assigned It should show uncheck
and if I check any uncheck box that particularly document should get assign to the that employee in the Employee shared document Database

if it is possible please let me know how to do it.

[v-jefferni · Accepted solution]

Hi @PDRC ,

Based on your description, I have made a simple test for your reference.

Here are my tables, I assume there is no relationship created among them so there are no LookUp columns but only text columns:

Here is my test app:

Formula for Default property of Check box:

!IsEmpty(Filter(EmployeeSharedDocs,Documentname = Dropdown1.Selected.DocumentName,Employeename = ThisItem.EmployeeName))

Formula for OnCheck property of Check box:

Patch(EmployeeSharedDocs,Defaults(EmployeeSharedDocs),{Employeename:ThisItem.EmployeeName,Documentname:Dropdown1.Selected.DocumentName})

Result:

Best regards,

[PDRC]

Hello @v-jefferni 
Thank you so much for the help.😊