Power Platform Community Forum Thread Details

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

Categories:

General topics