Hi @iskhj000 ,
Do you want to get the table which has the Address’s TCG# is match your second table?
I think you can change your formula expression as next:
Initial Collection: ClearCollect(CollIncompletesv6, Deactivation Incompletes)
Add Address Collection:ClearCollect(collUpdated6,AddColumns(CollIncompletesv6,”AddressLot”,LookUP(‘Master List’, TCG#= CollIncompletesv6.TCG#,Address)))
I test as this:
Button.Onselect: ClearCollect(test2,'[dbo].[Table_20190222DI]');ClearCollect(test3,AddColumns(test2,"Addresslot",LookUp('[dbo].[Table_20190222MasterTable]','TCG#' in test2.'TCG#',Address))) (on your side you can change to your tale’s and column’s name)
Hope this can be helpful.
Thank you Yumia
I think this is close but I am getting the same results as you... but... the addresses end up being the same for all of the records in the updated collection
I was needing the final collection to look like
123 101 no where street
789 103 hereweare dr
Try the following (going back to your original collect statement rather than creating another one).
ClearCollect(collUpdated6, AddColumns(CollIncompletesv6, "AddressLot", LookUp('Master List', 'TCG#'=CollIncompletesv6[@'TCG#']).Address))
This should give you the original collection you wanted - the difference here is the use of a disambiguation operator that will observe your Record Scope properly.
See if that helps.
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand