Color change per item in a dropdown list or second column text depending of an item

(0) Share

Report

Posted on by fatimaandrea

113

Hi,

Thanks for your help in advance. So I have a collection:

ClearCollect(ColorCollection; Sequence(100;0;1)). It contains numbers for 0 to 99, but I want to change the color of the value if this value is already present on a column named ATA that contains some numbers from 0 to 99 (ATA is a column where some values could be repetitive, so I use :

Distinct(Sort('Attachement digitalisation (test)'; ATA); ATA)

So, for exemple, if 0 exists on the list, I want the same value on the list Sequence from 0 to 99 to be on a different color (for exemple in red instead of black), indicating this value it's already on the list. But I was doing some research and apparently, you can not change a value individually. So If this is not an option, maybe adding a combobox with two columns and when the value on the sequence list matches the one on the ATA column, a text will show on the second column of the combobox like "this value has several records". I do not want a gallery, since this will not allow me to have the format I want.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (3)

Sort by

Verified answer

Akser 1,546 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @PowerAppsMx,

Do you mean something like this?

ClearCollect( ColorCollection, AddColumns( Sequence( 100, 0, 1 ), "Note", If( Value in 'Attachement digitalisation (test)'.ATA, "This value has several records" ) ) )

Was this reply helpful? Yes No
fatimaandrea 113 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you

Was this reply helpful? Yes No
Verified answer

fatimaandrea 113 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, I put it on the combo box with the following formula on Items :
If(DDaction.SelectedText.Value="Ajouter"; ColorCollection ;Distinct(Sort('Attachement digitalisation (test)'; ATA); ATA)) and using your formula on the collection and it worked, thanks !

Was this reply helpful? Yes No
Verified answer

fatimaandrea 113 on at

Like
a
(0)

Report
Copy link

Link copied!

So what I did was to create two collections:
ClearCollect(
ColorCollection;
AddColumns(
Sequence(
100;
0;
1
);
"Note";
If(
Value in 'Attachement digitalisation (test)'.ATA; "";
"Sans enregistrements"
)
)
);;

ClearCollect(ColorAll;AddColumns(Distinct(Sort('Attachement digitalisation (test)'; ATA); ATA); "Note1"; If(
Value in 'Attachement digitalisation (test)'.ATA; " ";
"0 enregistrements trouvés"
)
)
)
Then, I added a combo box with the following formula on Items:
If(DDaction.SelectedText.Value="Ajouter"; "Rechercher une ATA"; DataTable1.Selected.ATA)
And I chose the option to add two columns. When I click on ADD I know if there are records (or not) and when I click on modify, I only get the records.

Was this reply helpful? Yes No