You’re offline. This is a read only version of the page.
Hi Everyone,
I have two columns in my Dataverse table, ControlID and Control Description
In the dropdown I want to show both of these values with a separation of '-'
I tried the following in the items Property Its not working
Filter(Controls, ControlID & " - " & ControlDescription)
Could anyone please help with these
Share
Report
All responses (
Answers (
ClearCollect(
Dropdownlist,
AddColumns(
Controls,
Value,
ControlID & " - " & ControlDescription
)
)
Let me know if it helped you.
Here's the Documentation: AddColumns, DropColumns, RenameColumns, and ShowColumns functions - Power Platform | Microsoft Learn
To achieve this you would need to create a collection to create this column. However you can also create it with a Calculated Column in Dataverse and just use this column instead.
This way you could use every column of the tabele with DropDown.Selected.ColumnName
the other way you would need to find a way to LookUp to Dataverse for everithyng.
Let me know which way you want to use.
hi @Danny_Dicaprio ,
You can create a collection in the OnVisible property of the screen or in the OnStart property of the app. For example, in the OnVisible property of the screen:
ClearCollect(
CombinedControls,
AddColumns(
Controls,
"DisplayValue",
ControlID & " - " & ControlDescription
)
)
This formula creates a new collection called CombinedControls, which adds a new column called DisplayValue to the Controls table, combining ControlID and Control Description with a hyphen.
Set the Items property of the dropdown to the new collection:
CombinedControls
#1
WarrenBelz
146,552
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,928
Most Valuable Professional
