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 Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,733)