Good morning Community. Happy Friday!
I have this question and I hope someone could point me in the right direction:
I have 3 Sharepoint lists:
Departments
Employess
Cards.
I have my "Form" connected with my SPL "Cards" in that list I am saving the ID's of the selected items in my comboboxes. When I am in edit/new mode I would like to see the combobox value not the ID, but still able to save the ID once the item is selected.
For instance in the below chart I have selected for department "Quality" and for employee "Louis M" and I am saving those ID's in my SPL "Cards".
But the default value of those combobox I would like to see the value instead of the ID, Something like a Vloopup against the collection?
I don't know, I have been trying to figure out with no success.
Thanks in advance for any help.
Regards.
Solved! Go to Solution.
For the Departments Combobox:
Items property should be: Departments
DefaultSelectedItems property should be : LookUp(Departments, ID=Parent.Default)
For the Employee combobox:
Items property should be : Employees
The DefaultSelectedItems property should be: LookUp(Employees, ID=Parent.Default)
The Collections and ShowColumns are just extra overhead for your app and you don't need them.
I hope this is helpful for you.
EDIT: I realized you mentioned you were just storing the ID (I had assumed a Lookup column). I've adjusted the above to reflect what you have.
For the Departments Combobox:
Items property should be: Departments
DefaultSelectedItems property should be : LookUp(Departments, ID=Parent.Default)
For the Employee combobox:
Items property should be : Employees
The DefaultSelectedItems property should be: LookUp(Employees, ID=Parent.Default)
The Collections and ShowColumns are just extra overhead for your app and you don't need them.
I hope this is helpful for you.
EDIT: I realized you mentioned you were just storing the ID (I had assumed a Lookup column). I've adjusted the above to reflect what you have.
Oh boy. Thank you very much. I will adjust accordingly. I thought that making collections was a good practice instead of working against the data. but I will follow your advice
There is no value to the collections in this case, unless you are working offline or have a need to add or remove rows to the collection in your app.
As for the ShowColumns, it is a misunderstanding that using the ShowColumns reduces the amount of data transferred (and thus it is a good performance tip)...it is not. The DataSource always returns all the columns, the ShowColumns just takes that table and removes all the other not mentioned columns. So, really, in this context, it's just more or a hit on performance for the extra step.
Now...keep in mind, both Collections and ShowColumns have their place and value. Just not in your case.
Oh Boy, I would like to do something like the Matrix needle scene. I need to transfer your knowledge.
Thank you very much.
Problem solved.
I'm working on that App 😂😂 For now we can only choose the red pill or the blue pill. 😁
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
User | Count |
---|---|
202 | |
100 | |
61 | |
59 | |
57 |
User | Count |
---|---|
254 | |
163 | |
90 | |
79 | |
70 |