Using Flow to create a variable and then use in a 'query'

%3CLINGO-SUB%20id%3D%22lingo-sub-98310%22%20slang%3D%22en-US%22%3EUsing%20Flow%20to%20create%20a%20variable%20and%20then%20use%20in%20a%20'query'%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-98310%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20-%20I%20am%20creating%20a%20Flow%20to%20do%20the%20following%3A%3C%2FP%3E%3COL%3E%3CLI%3EOn%20item%20modified%3C%2FLI%3E%3CLI%3EInitialize%20variable%20'shortnameVar'%20-%20set%20to%20single%20line%20of%20text%20field%20with%20multiple%20value%20'shortname1'%20(this%20field%20will%20contain%20values%20like%20ABD%20DEF)%3C%2FLI%3E%3CLI%3EGet%20Items%20from%20another%20list%20(in%20this%20list%20are%20items%20where%20'shortname2'%20exists%20but%20with%20only%20one%20value.%3C%2FLI%3E%3CLI%3EApply%20to%20each%3C%2FLI%3E%3CLI%3EOutput%20from%20previous%20step%20-%20Value%2C%20with%20condition%20of%20'shortname2%3Avalue'%20contains%20'shortnameVar'.%3C%2FLI%3E%3C%2FOL%3E%3CP%3EI%20am%20essentially%20trying%20to%20use%20a%20list%20item%20column%20that%26nbsp%3Bwill%20contain%20a%20single%20entry%20to%20query%20a%20column%20that%20may%20contain%20multiple%20entries%20to%20extract%20only%20those%20that%20evalute%20to%20true.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-98310%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-99881%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20Flow%20to%20create%20a%20variable%20and%20then%20use%20in%20a%20'query'%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-99881%22%20slang%3D%22en-US%22%3E%3CP%3EI%20did%20some%20moving%20around%20and%20modificiations%20to%20the%20Flow%20and%20got%20it%20to%20work%20as%20wanted%20in%20the%20end.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

Hi - I am creating a Flow to do the following:

  1. On item modified
  2. Initialize variable 'shortnameVar' - set to single line of text field with multiple value 'shortname1' (this field will contain values like ABD DEF)
  3. Get Items from another list (in this list are items where 'shortname2' exists but with only one value.
  4. Apply to each
  5. Output from previous step - Value, with condition of 'shortname2:value' contains 'shortnameVar'.

I am essentially trying to use a list item column that will contain a single entry to query a column that may contain multiple entries to extract only those that evalute to true.

 

Thanks

1 Reply

I did some moving around and modificiations to the Flow and got it to work as wanted in the end.