Could you please explain a bit for the unique items here? If you mean an item filtered with some special condition, then I think the filter Array Action would work with your scenario.
Personally I think the selection from Array is not available.
The data being queried are not pre-loaded when configure the flow, so there is no data could be chosen from the array,
Further, the data which would be loaded in array might change, the pre-configured item may not work.
what we could do when configure the Flow is working with conditions, or the available OData Query option, such as fiter query, orderby, or select query (in SQLServer).
If I misunderstand something, please let me know.
Use the built-in union or intersection functions. They are both fast and require few steps:
See here for more details: https://medium.com/@martinfy/the-fastest-way-to-find-unique-items-with-flow-f9618ef7224
We are excited to announce the launch of Power Virtual Agents Community. Check it out now!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!