Answered

Dropdown add a value with formula & add a value by hand

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello there!

I want to fill a dropdown with a formula & add an extra static value, how can I do this?

This fills the gallery with the items from my sharepoint list, but I need to add a value like "Test" to it

My formula:

Sort(
 Distinct(
 Filter(
 'D-Nummers-OpleverApp';
 Dropdown3.SelectedText.Result = Order
 );
 Verdieping
 );
 Result
)

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous

With({filtrd:Distinct( Filter( 'D-Nummers-OpleverApp'; Dropdown3.SelectedText.Result = Order ); Verdieping ) }; Sort( Ungroup( Table( {MyTables: Table({Result: "Test"})}; {MyTables: filtrd} ); "MyTables" ); Result ) )

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@Drrickryp Thank you for your answer!

Now I want to have the "Test" filter on this; 'D-Nummers-OpleverApp';
Dropdown3.SelectedText.Result = Order

How can I do this?

Was this reply helpful? Yes No