I have 2 tables, one called "Items" with ItemId, Name.
And one called "Price" with Itemprice, ItemId.
We can make a Join Based on "ItemId".
How can I show ItemId,Itemprice,Name in the same table?
I read about "addcolumns", "filter", etc. But I can't do it and it seems too easy.
Thx for all, regards.
Solved! Go to Solution.
I hope the following, may help you..
Button2.OnSelect = ClearCollect(Join,AddColumns(Items,"Price",LookUp(Price,ItemId=Items[@ItemId],Itemprice)))
Thanks for the answer, I dont want to do it with buttons, I need to show it in a table.
That Join that you use there I cannot use it. ClearCollect(Join,AddColumns...
Need another solution.
That's it!! it works fine, I accept it as a solution, but I have another question:
How can I make a "where" syntax?
Imagine I want to show only the items that price > 10, do you know how to do it?
Lot of thanks mate.
The documentation on filter function can help you
The images helps amigo.. 🙂
The beginning of the second line... ---> deno.Text in '[Dim],[DimSIE]'
Can you change it into ----> Denominacion= deno.Text ?
Does it work?
Also you use the the filter function. I think its better to use the search function:
If not I would start from the beggininng.
Set the gallery items only with the addcolumns.
If it works, go to the filter..
If it works, go to the showcolumns..
The two tables that you use.. How many records do they have? More than 500?
Check out new user group experience and if you are a leader please create your group
Check out how to claim yours today!
Test your skills now with the Cloud Skill Challenge.
We are excited to announce that Demo Extravaganza for 2021 has started!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks