Power Platform Community Forum Thread Details

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!

Categories:

Building Power Apps