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.
Solved! Go to 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,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.
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,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.
User | Count |
---|---|
256 | |
106 | |
86 | |
51 | |
43 |