HI.
Solved! Go to Solution.
Hi @Anonymous :
Firstly,currently powerapps does not support full join.
Secondly, similar functions can be achieved by a combination of functions.I've made a test for your reference:
My data source(for some reason, I cannot download the attachment you provided):
collection1/collection2
ClearCollect(collection1,{UPC:"A",LOCbyQty:53},{UPC:"B",LOCbyQty:4},{UPC:"C",LOCbyQty:4},{UPC:"D",LOCbyQty:2});
ClearCollect(collection2,{UPC:"A",PackbyQty:51},{UPC:"B",PackbyQty:4},{UPC:"C",PackbyQty:5},{UPC:"E",PackbyQty:5})
1\add a datatable control and set it's items property to:
RenameColumns( /*Renamed "Result" column to "UPC"*/
AddColumns( /*Add two fields LOCbyQty and PackbyQty, use lookup to find the corresponding values in the two tables*/
Distinct(/*Get the UPC values of the two tables, and get the single column list of UPC after deduplicating the results*/
Split(
Concatenate(
Concat(
collection1,
UPC,
"#"
),
"#",
Concat(
collection2,
UPC,
"#"
)
),
"#"
),
Result
),
"LOCbyQty",
LookUp(
collection1,
UPC = Result
).LOCbyQty,
"PackbyQty",
LookUp(
collection2,
UPC = Result
).PackbyQty
),
"Result",
"UPC"
)
Best Regards,
Bof
Hi @Anonymous :
Firstly,currently powerapps does not support full join.
Secondly, similar functions can be achieved by a combination of functions.I've made a test for your reference:
My data source(for some reason, I cannot download the attachment you provided):
collection1/collection2
ClearCollect(collection1,{UPC:"A",LOCbyQty:53},{UPC:"B",LOCbyQty:4},{UPC:"C",LOCbyQty:4},{UPC:"D",LOCbyQty:2});
ClearCollect(collection2,{UPC:"A",PackbyQty:51},{UPC:"B",PackbyQty:4},{UPC:"C",PackbyQty:5},{UPC:"E",PackbyQty:5})
1\add a datatable control and set it's items property to:
RenameColumns( /*Renamed "Result" column to "UPC"*/
AddColumns( /*Add two fields LOCbyQty and PackbyQty, use lookup to find the corresponding values in the two tables*/
Distinct(/*Get the UPC values of the two tables, and get the single column list of UPC after deduplicating the results*/
Split(
Concatenate(
Concat(
collection1,
UPC,
"#"
),
"#",
Concat(
collection2,
UPC,
"#"
)
),
"#"
),
Result
),
"LOCbyQty",
LookUp(
collection1,
UPC = Result
).LOCbyQty,
"PackbyQty",
LookUp(
collection2,
UPC = Result
).PackbyQty
),
"Result",
"UPC"
)
Best Regards,
Bof
Thanks for the answer. That solution is well used. Thank you every time.
The solution provided by the respondent can get a quick answer.!!
Button on Select :
Collect(Collection3,AddColumns(GroupBy(collection1,"UPC","ByUPC"),"LOCbyQty",Sum(ByUPC,LOCbyQty)),AddColumns(GroupBy(collection2,"UPC","Byupc2"),"PackbyQty",Sum(Byupc2,PackbyQty)))
Dataform Item :
AddColumns(GroupBy(Collection3,"UPC","Fullouter"),"LocbyQty",Sum(Fullouter,LOCbyQty),"PackbyQty",Sum(Fullouter,PackbyQty))
Will it be a problem part?
Best Regards,
Hi @Anonymous :
Your method is good without any problems.
Could you tell me:
Best Regards,
Bof
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 |
---|---|
196 | |
174 | |
62 | |
33 | |
32 |
User | Count |
---|---|
339 | |
270 | |
109 | |
76 | |
59 |