Hi @Anonymous ,
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 out new user group experience and if you are a leader please create your group
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
Did you miss the call? Check out the recording here!