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.
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.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!