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

[Erik Nelson]

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!

[GlideFather]

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:

 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

[GlideFather]

@Erik Nelson Or eventually here:

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

[Erik Nelson]

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.