Show the text and not the code in a column of a datatable - DB EXCEL

[kishama]

Hello,

I have tables in excel that are "related" by the id. When I display my main table tickets in the userid and customerid columns, it should display the username and customername from their respective associated tables by ID.

My database is in excel, I cannot use sharepoint or dataverse because it is blocked for my user within the company.

My user table:

My customer table:

My main table:

My Datatable in power apps:

I want to display username and client name in my databable.

Thanks for your quick response.

[timl · Accepted solution]

@kishama 

Set the Items property of your data table control to:

AddColumns(YourMainTable,
   "cliente",
   LookUp(YourCustomerTable, idcliente = YourMainTable[@idcliente]).cliente,
   "nombres",
   LookUp(YourUserTable, idusuario = YourMainTable[@idusuario]).nombres
)

You can then add the cliente and nombres fields to your datatable.

Note if you're using Power Apps in Spanish, you'll need to replace the , symbols in the formula with ;.

[kishama]

Hi @timl 

I'm happy, thank you very much, I thought you couldn't.

I need your personalized help, if you have time to help me in this app. I can pay for your services.

Please help. Thank you

[kishama]

Hi @timl,

I am applying your advice. but now my search code no longer works. How could I solve this problem. 

I would also like to know how I can center the text of each column that I am adding. Thank you so much.