cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cescari
Frequent Visitor

Collection column is not poulated

I've in the Default property of an input text the following expression:

Concat (Contactos_Seleccionados; Proper(NOMBRE_CONTACTO) & ": (" & Lower(EMAIL_CONTACTO) & ")")

Both fields come from the same table in the Dataverse but the final result is:   ": (aaaaaaaaa@email.com)". Both fields "NOMBRE_CONTACTO" and "EMAIL_CONTACTO" are present in the collection "Contactos_Seleccionados". But the column "NOMBRE_CONTACTO" isn't populated with any value, so the final result isn't the expected, user's name isn´t displayed.

- The table has the right values in both columns. (Sorry not to display them, but the values are the real ones...)

- The application is saved and published.

- The solution is published, as well.

Do I have something special to do after the last update in the Dataverse?

Any suggestion?

 

Thanks in advance

1 REPLY 1
timl
Super User
Super User

@cescari 

The cause of this will be the 'explicit column selection' setting of your app. You can either disable this in the settings (not recommended), or you can call ShowColumns to explicitly specify your columns when you create your collection.

ClearCollect(Contactos_Seleccionados,
             ShowColumns(YourDataverseTable,
                         "NOMBRE_CONTACTO",
                         "EMAIL_CONTACTO",
                         "etc"
             )
)

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Users online (1,594)