Look up all "true" values for use in a Flow

Erik Nelson
Kilo Sage

Hello!

Not sure this is something possible, but I'm hoping to simplify some of how I build an app I've just started on. I'm going to currently have a whole bunch of True/False fields that drive lookups for other information as part of the "intake" for the app. They each essentially drive making associated fields visible and mandatory in a somewhat clean fashion. I'm then using those as a reference point to do a lookup of associated records and populate a second table with data from the intake along. At a super high level:

  • True/False fields are for things like Area 1, Area 2, Area 3, and Area 4.
  • When checked, the Area has its own independent Start and End date fields
  • When the record is saved, the Flow looks up all the items associated with the Area and writes an entry into a table giving Item with a Start and End Date

My starting point for "Areas" is 31 entries, so I obviously don't want to take up 32 lines of my Flow just with "If Area 1 = True", "If Area 2 = True", etc. My question is: Is there a straightforward method to look up and return the true values, to then use in them as part of a "for each" that can drive the remaining Flow?

 

Thanks!

3 REPLIES 3

GlideFather
Tera Patron

Tjena @Erik Nelson,

 

not sure if it's what you're looking for but let's try...

 

Navigate to the [wf_activity_variable] table and filter for Type == boolean:

GlideFather_0-1759263663859.png

 

 Change the URL and navigate to:

https://yourinstance.service-now.com/wf_activity_variable_list.do?sysparm_query=internal_type%3Dboolean

 

Let me know if it got you closer, good luck

———
/* If my response wasn’t a total disaster ↙️ drop a Kudos or Accept as Solution ↘️ Cheers! */


@Erik Nelson Or eventually here:

 

https://yourinstance.service-now.com/sys_variable_value_list.do?sysparm_query=variable.internal_type%3Dboolean

 

GlideFather_1-1759263845488.png

 

———
/* If my response wasn’t a total disaster ↙️ drop a Kudos or Accept as Solution ↘️ Cheers! */


Not really what I'm looking for. I'm trying to say "Look up all fields on this record where value = true and give me those for use".  So using my example from above:

  1. Person fills out form and sets Area 1, 3, and 4 to "true"
  2. Script/Flow/Combo looks up and provides for use that all three of those values are "true"
  3. I can then use each of those found true values to feed into a next lookup.

Hope that provides more clarity.