You’re offline. This is a read only version of the page.
Hi. I have a Combo Box that I created on a Data Card to replace a People field with a dropdown. It shows the dropdown and updates the SP List backend like expected, but when I click on the item in Power Apps to edit, the value that was selected in the Combo Box is blank. I'm using the same form for New and Edit. I added Parent.Default and also tried [Parent.Default] on the DefaultSelectedItems property.
I tried adding another combo box in a people picker data card and it's doing the same thing. What am I missing?
@nancykoopmann - raise a new post with your question rather than replying to a closed thread.
I have a similar problem where 4 of my fields are not showing up on the edit form. I tried to set the value to 'Display Name' per you screen shot, but my only choice is 'Value'. I am having trouble with fields where I have coded a default value that was originally set on the sharepoint form. The default shows up on the NewForm and on the SP List but it is empty on the EditForm. Date field, Choice Fields... my code for the default is
Hi @theBrianL ,
You may need to change the display value of the combobox. Please follow the steps in the attachment to change the display value of the combobox items.
There are multiple threads on this forum on adding the Office365 user table and then adding that as the items property of your people picker, but I have found running filters on it unhelpful. Not because of the logic used, but because every organisation has certain nuances when it comes their Office365 data.
https://powerusers.microsoft.com/t5/Building-Power-Apps/Filter-people-picker-list/td-p/236282
After the users fill out the form, they hit the submit button and the On Select is set to SubmitForm(EditFMM).
It's no worries, I may just revert back to using the people picker without the dropdown and have it set to a SP Group. I just like the ease of a dropdown. Thx for all the dialogue. If you think of any ideas to make a limited dropdown people picker, please let me know.
That still would not work because as mentioned, when you update a People field it is expecting a type Record and not type Text. Even if that Text value looks the same as the field being displayed (in your case the Display Name) it would still not work.
There must be something else you're doing which is allowing you to update the People field with the value of the dropdown.
Are you using a Patch statement or a SubmitForm?
The single line of Text field that the combo box references are the exact typed names of people i.e. the Display Names. So when it populates the name in the people of the other SP list column it works. That's the only way I could figure out how to make a dropdown for People. I made this work on another App but it had separate screens for edit and new, but it seems there would be a way to just reference that SP Item in a field.
Well, I wish I started with that question first. A Choices data type returns a TABLE of values. In case of a Person column, it not only returns a TABLE but also a record with different fields in the record. The record will have a pattern which looks like:
{
Claims: ,
Email: ,
DisplayName:"",
JobTitle:"",
Picture:""
}
A People column will not accept type Text type as an acceptable value. But according to your notes, you have managed to update the People column with a single line Text field. How?
This is the Items Property: Sort(FMMList,FMMDisplayName,SortOrder.Ascending). If I change the Items property to Choices([@MarketingCostShare].FMM) it shows up, but that messes up the whole dropdown.
Yes, I'm using the combo box to select names from another SP List to update the People Field, in order to limit the number of selections. The combo box reference a field called FMMDisplayName, which is a text field. All of the other fields are not blank. Just two combo boxes that do the same function are blank.
What is the Items property of this Combo Box?
Also, given a form automatically creates a people picker combo box for your people field, there must be a specific reason you're creating another one with the same functionality?
I also assume all of the other data cards are not blank?
#1
WarrenBelz
146,524
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,906
Most Valuable Professional
Share
Report
All responses (
Answers (
