Hey guys, I am going nuts trying to figure this out. I have a SharePoint list (called A-MAP) with two columns named "FHA Number" and "Property Name" (see first screenshot). I've created a data card for a user to select the FHA Number from a dropdown (called FHA Number_Dropdown). When a user selects an FHA Number, I want the Property Name field in the app (called Property Name_Input) to populate with the data from the SharePoint list. I used 'FHA Number_Dropdown'.Selected.'Property Name' as the Default of Property Name_Input, but it doesn't recognize the 'Property Name' column from the SharePoint list. Please help!
Solved! Go to Solution.
Helpful and important to know!
Anyway, from what I saw in your previous picture, the formula editor WAS showing the proper value for 'Property Name' so something else is gone a little strange in your control.
Replace the 'FHA Number_Dropdown'.Selected.Title in the Default property to be just : "Hello"
Does it show "Hello"?
No? The textinput control is gone wanky, save your app and close and then open again. Same? Remove the textinput (ctrl-X) and then undo (ctrl-Z)
Yes? Put a label somewhere on your screen and set the Text property to : 'FHA Number_Dropdown'.Selected.Title
Does it show the proper values?
What is the formula for the Items property of FHA Number_Dropdown ?
Hi, try giving the following formula a go in the 'Item' property of your Property Name field:
Filter('YOURDATASOURCEHERE', PROPERTYNAMEFIELDHERE = DataCardValue6.Selected.Value)
In the last bit, where it says DataCardValue6, you should put your dropdown to filter from + .Selected.Value
Hope it works. Take care
Yes, so this is going to give you a table with a single column called "Result". You will not have the full record which will include the 'Property Name' column.
So, this brings the next question - why are you using Distinct? And, if you are doing so because you have duplicate values and want a distinct list, then, if a user selects an item in the dropdown, how will you know which record is really the 'Property Name' that you want?
Randy, I don't know why I am using Distinct. I will take it out. At some point, someone advised me to use Distinct there. Also, there are no duplicate values to worry about.
What formula do you recommend in the Items property of FHA Number_Dropdown?
Yeah, you don't need distinct unless you have duplicate values that you want to filter out. But in your case, I believe you don't have them and the second bit of information - the property name - is important.
So, set your Items property formula on the Dropdown to :
If you want them sorted, then:
SortByColumns('A-MAP', 'FHA Number')
You will then have the 'FHA Number_Dropdown'.Selected.'Property Name' column available for your Property Name_Input default property.
Also, as an extra bonus - Distinct is not a delegable function, so, technically, if you don't need it, you could have introduced problems down the road should your list grow beyond your record limits in the app.
So to recap, what is your Dropdown Items formula and your TextInput control default property?
Join us for the next call on August 17, 2022 at 8am PDT.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.