Hello All,
I need help in if and how the following logic can be implemented with a PowerAutomate flow.
Code Logic:
- Get distinct list of suppliers from Supplier portfolio table(SupplierId is a lookup column)
- For each supplier get the list of activities to a collection - loop1 (ActivityId is a lookup column)
- Now there are N collections created
- Sort the collections by count of elements in desc order
- For each collection, iterating in a loop, check if each item is present in any other subsequent(next in the sorted order) collections(not the previous ones) and remove the elements of current collection from other collections which are - inner loop2
- Now insert each collection to a package table.
Please help me with some references to looping, collections and sorting required for the logic. I am also facing many errors while applying filters to lookup columns. Appreciate any help.
Thanks,
Haripriya