add personalized item to Items properties

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi All

how i do this, i need to add a personalized value into a Items propertie wich is result from formula. something like this:

["Item_personalized";
Proper(
 Sort(
 Distinct(
 Filter(
 colecaotudo;
 'Planned to' > 0
 );
 Year('Planned to')
 );
 Result <> Blank();
 Ascending
 )
)]

i know this works

["item1";"item2";"item3":"Item4"]

and this isolated works too

Proper(
 Sort(
 Distinct(
 Filter(
 colecaotudo;
 'Planned to' > 0
 );
 Year('Planned to')
 );
 Result <> Blank();
 Ascending
 )
)

if i try this :

Concatenate(
 Proper(
 Sort(
 Distinct(
 Filter(
 colecaotudo;
 'Planned to' > 0
 );
 Year('Planned to')
 );
 Result <> Blank();
 Ascending
 )
 );
 "Item_Personalized"
)

i have the item 2022Item_Personalized

but i want a list to use on a dropdown.

some idea how to do this?

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

You would not be able to add to the table that way.

The following formula should provide what you are looking for:

Ungroup( Table({Items: Table({Result:"Item_personalized")}; {Items: Proper( Sort( Filter( Distinct( Filter(colecaotudo; 'Planned to' > 0); ); Result <> Blank() ); Year('Planned to') ) ) } ); "Items" )

I hope this is helpful for you.

Was this reply helpful? Yes No