You’re offline. This is a read only version of the page.
Announcements
364
Hi All,
Like the title says, I am wondering if it is possible to add a few options to a filtered combobox list. Here is my code in the items property:
Filter( 'Microsoft Projects_TASKSs' , cr9dc_projectname = ComboBox1.Selected.cr9dc_projectname )
ComboBox1 contains each project that a task belongs to. The issue is, we have hundreds of projects and I need to add:
"Production", "Clerical", "Meetings", "3D Print", "VEC - Test", and "CAL - Test" as task options for each project. Adding them manually would be very time consuming.
The 'Microsoft Projects_TASKSs' is updated via dataflow daily, so I cannot manually add these options to the table, or they will be automatically removed. Does anyone know if it is possible to add some additional options after my filtered formula? I have tried things like:
Filter( 'Microsoft Projects_TASKSs' , cr9dc_projectname = ComboBox1.Selected.cr9dc_projectname ) && ["Production", "Clerical", "Meetings", "3D Print", "VEC - Test", "CAL - Test"]
But this obviously does not work. I have also tried following the advice https://www.matthewdevaney.com/create-a-dropdown-with-an-other-option-in-power-apps/ without any success, I believe mainly due to the fact I am not using a choices column.
Any help or clarification on how this works would be greatly appreciated!
Hi @Aurora ,
I have assume the field name Tasks here - change if necessary
Share
Report
All responses (
Answers (
Ungroup(
Table(
{
Data: ["Production", "Clerical", "Meetings", "3D Print", "VEC - Test", "CAL - Test"]
},
{
Data:
RenameColumns(
Filter(
'Microsoft Projects_TASKSs' ,
cr9dc_projectname = ComboBox1.Selected.cr9dc_projectname
)
"Tasks",
"Value"
)
}
),
"Data"
)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
MVP (Business Applications) Visit my blog Practical Power Apps
