Hi all,
I have a collection "CollectModule" that stores the list of modules of the project selected. If the module is removed from the collection, the status of the module will be updated to "Remove". CSP_S0150_Projects is my SQL table name and both of the collection and the SQL table share the same column names. I'm using a ForAll function to 'loop' through all the record in "CollectModule" to remove it from SQL.
From my research, since both of them have the same column names, it seems like I have to use disambiguation operator inside my LookUp. My question is, why is it returning an error when it's working for the situation mentioned here: https://powerusers.microsoft.com/t5/Building-Power-Apps/Forall-Patch-issue/td-p/568058 ?
My error:
My code:
ForAll(
Filter(CollectModule, Status="Remove"),
Remove( CSP_S0150_Projects,
LookUp( CSP_S0150_Projects, CustID=CollectModule[@CustID] && ProjectName=CollectModule[@ProjectName] && Module=CollectModule[@Module]))
)
Any help or suggestion is hugely appreciated. Thanks!
