cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kishama
Helper I
Helper I

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

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:

kishama_0-1653318509179.png

My customer table:

kishama_1-1653318668124.png

My main table:

kishama_7-1653319548684.png

My Datatable in power apps:

kishama_4-1653318937360.png

kishama_5-1653318969668.png

kishama_6-1653318996150.png

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

Thanks for your quick response.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
timl
Super User
Super User

@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 ;.

View solution in original post

3 REPLIES 3
timl
Super User
Super User

@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
Helper I
Helper I

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

 

Hi @timl,

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

kishama_0-1653337015656.png

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

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (1,541)