Hi all,
I have recently experienced that there is a limit to the amount of LookUp columns we can use in a single PowerApp.
Therefore, I am trying to get rid of LookUp columns, which I can change into other types of columns.
In my SharePoint List I have a column called "Sales Responsible", this looks up values from ANOTHER list called "Employees".
Now I have created a simple textfield column in which I have deleted the textfield and inserted a customizable DROPDOWN. I have connected this dropdown to the employee-list and have set the Update Property of the DataCard to:
ddSalesResponsible.Selected.'Name ({Name})'
The Items Property of the Dropdown itself:
Sort('Dogma Alares Employee List SPM'.'Name ({Name})',Ascending)
The Default Property of the Dropdown itself:
If(SPMEdit.Mode = FormMode.Edit, Parent.Default, "-")
The strange thing now is that when I submit the editform and go to the viewform of this project, it does not show up. It simply leaves the field blank.
If I go back into the editform the selected Name from the employeelist is correctly saved and shows up as intended.
What am I doing wrong?
I am really struggling with sharepoint when having to modify Dropdowns let alone Combobox's
EDIT: It is important to note that this employee sharepoint list is dynamic and will have to be connected to a list rather than just writing the names into a choices column or something along those lines.

Report
All responses (
Answers (