Here's the situation:
My app allows reading and writing on 2 different tables (both come from excel but one is Table_A and the other Table_B). These 2 tables have a common field as far as name is concerned: Serial_number. I'm looking to create a list of all the serial numbers of both these tables, list that could be used to select an item from it and do things with it.
Example: In the same list (let's call it List_C) I want to be able to either select item_from_table_A or item_from_table_B, the selection process being based on the common field: serial_number.
Is there any way of achieving this in Power Apps ?
Solved! Go to Solution.
@Anonymous
You can collect both lists into one with a formula such as this:
ClearCollect(List_C, Table_A, Table_B)
If they both have the same columns, you will have one long list.
If they have dissimilar columns then you will have a collection with all items and all columns.
If serial_number is common in both list, then that column will be included and be populated from both sets of items.
If ALL you want is the serial_number columns, then you can use a formula such as this:
ClearCollect(List_C, ShowColumns(Table_A, "serial_number"), ShowColumns(Table_B, "serial_number"))
I hope this is helpful for you.
@Anonymous
You can collect both lists into one with a formula such as this:
ClearCollect(List_C, Table_A, Table_B)
If they both have the same columns, you will have one long list.
If they have dissimilar columns then you will have a collection with all items and all columns.
If serial_number is common in both list, then that column will be included and be populated from both sets of items.
If ALL you want is the serial_number columns, then you can use a formula such as this:
ClearCollect(List_C, ShowColumns(Table_A, "serial_number"), ShowColumns(Table_B, "serial_number"))
I hope this is helpful for you.
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
204 | |
188 | |
80 | |
50 | |
38 |
User | Count |
---|---|
305 | |
251 | |
121 | |
73 | |
55 |