Use Flow to return a single collection and its products

Topic summary

A user is attempting to use Shopify Flow to automatically update product metafields, but only for products within a specific collection. Despite efforts to restrict the flow to one collection through queries, the automation is applying changes to all products instead of the targeted subset.

Key Challenge:

  • When using a non-product-based trigger (specifically ‘event started’ via Launchpad), the collection restriction fails
  • The intended use case is adding a ‘sale’ badge metafield to products in one collection when a Launchpad event triggers
  • Currently, the flow incorrectly adds sale badges to random products outside the target collection

Current Status:

  • The user has shared screenshots of their Flow configuration and query setup
  • They’re questioning whether their query syntax is incorrect or if the Flow structure itself is flawed
  • Seeking confirmation on whether this type of collection-specific automation is even possible with Flow

The discussion remains open with no resolution yet provided.

Summarized with AI on October 29. AI used: claude-sonnet-4-5-20250929.

I want to use flow to automate updating product metafields. I only want to modify the products in a singular collection. I’m having a heck of a time getting flow to restrict itself to one collection. Am I writing the query wrong? or do I have the flow mixed up?

Is this even possible? Or am I just wasting my efforts?

Attached are some visuals to help explain what I am trying to do.

Thanks. I appreciate any insights.

Thanks Amanda -
What if the trigger is not product based? But rather ‘event started’… I am using launchpad, and want an event to trigger the update of a ‘sale’ badge in only 1 collection… And even though I try to restrict the collection, it just returns everything and adds random ‘sale’ badges to my products that are simply not on sale. It’s quite puzzling.

Thanks,
Brenda