@tagustin2020
Very good (and as always...well documented- Thanks!!). So what needs to be done is to add the information within the Items property of the dropdown control.
Your formula should be this:
ForAll(
With({_items: SortByColumns('Project List'.'Project Number',"Title")},
Sequence(CountRows(_items)+1, 0),
With({_item: Last(FirstN(_items, Value))},
{'Project Number': If(Value = 0, "- Select One -", _item.'Project Number'),
NumberAndName: If(Value = 0, "- Select One -", _item.'Project Number' & " - " & _item.'Project Name')
}
)
)
)
Now set the Value for the display field to "NumberAndName". This will give you what you want without any impact to anything else.
Note a couple changes I have made.
First is that I moved your SortByColumns on the project list into its own with variable. You had it in the middle of the Last(FirstN( in your original formula before. This change is a performance change as now the sort is done once instead of on every iteration of the sequence.
Second, I put another With in for the _item (the Last(FirstN bit), only because I would be referencing this item twice and I hate to repeat the same formula over and over.
Third, I changed the Sequence to start at 0. This is just a little cleanup from my original video that you got this from - When I did the video I did not realize I could start the sequence at 0. It is much cleaner that way.
I had originally asked about the two labels on the screen. I see the formulas in your document. Those could stand some attention as you already have the values from the Dropdown, there is no need to do lookups for both of them to get the values. BUT, this I did not address here and will only address should that become an issue for you.
Give it a go and see how things look.
