Hey Everybody,
I have a Formscreen (no Editform, just put the fields there) where i have a dropdown cotrol on it. As values i want to have data of a colum from a sharepoint list.
That is what i tried,its not giving me any errors but i also have no values when i play the app and click on the dropdown:
Distinct('Legal Entities and Heads', LegalEntity)
that should give ma all items in the dropdown but it does not. But i even need a more complex filter on the items in the gallery.
In this table you can see my colums and the description of what is inside the column. They are all single line of text colums.
| LegalEntity | HeadofEntity | HeadofEntityEmail | Editrole | Seerole |
| CompanyName | Name of Person | Email of Person | 0 or 1 | 0 or 1 |
If the Value of Editrole is 0 they only should be able to edit the items of the LegalEntity they are responsible for. If the value is 1 they should be able to edit every legalentity available.
they also only should be able to choose the legalentity they are resposible for in the dropdown.
if that important, i patch the submissions to another sharepoint liste (so not the same one). And yes i added them both as connections.
Someday i would need to apply the same filtering on the gallery where i store the finished submissions. if the Value of Seerole is 0 they can only see the entries of the LegalEntity they are responsible. If the Value is 1 they should be able to see all items inside th gallery.
can somebody help me with that?
