@Anonymous Maybe this approach will solve your needs. In my example I faked a list of customers. So, if you can produce a Table with unique customer names this solution will work.
ClearCollect(myCustomers,["Customer 1", "Customer 2","Customer 3","Customer 4","Customer 5"])
In a second step I used this code:
This code will "iterate" through all customers in myCustomers and returns a record with a Random RGBA value
ClearCollect(
_customerColorSetting,
ForAll(
myCustomers,
{
CustomerName: ThisRecord.Value,
fill: RGBA(
RandBetween(
1,
255
),
RandBetween(
1,
255
),
RandBetween(
1,
255
),
1
)
}
)
)
This will produce a Table like this:
to apply this to a customer record in a Gallery for example your code would look something like. You could for example place this in the TemplateFill Property of a Gallery:
LookUp(_customerColorSetting,CustomerName = ThisItem.Value).fill
The Items Property of my Gallery is set to "myCustomers"
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.
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.
