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.
Solved! Go to Solution.
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 ;.
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 ;.
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.
I would also like to know how I can center the text of each column that I am adding. Thank you so much.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
User | Count |
---|---|
162 | |
91 | |
67 | |
63 | |
62 |
User | Count |
---|---|
216 | |
158 | |
96 | |
86 | |
79 |