How to Relurn a List of Boolean Values

1

I have the first formula below, that returns a list of links.

Codes.Filter(Jurisdiction=thisRow.Jurisdiction AND [Doc Type]=“Integrated”).Reference

Output :

Wayback Machine ,
http://170.94.37.152/REGS/007.24.20-003F-21408.pdf ,
Wayback Machine ,
http://170.94.37.152/REGS/007.24.20-002F-21407.pdf ,

I want to check if these links contain certain word like ‘web.archive.org’. I used the code below :

RegexMatch(Codes.Filter(Jurisdiction=thisRow.Jurisdiction AND [Doc Type]=“Integrated”).Reference, “web.archive.org”)

However, it only returns a single boolean value. I expect it to return a list of boolean values. What shall I do ?

2

When you run the filter formula, it returns a list of values - therefore if you want to check if each value in your list individually matches your desired string, you will need to run the regex (or containsText formula) on each list item

That’s where ForEach() comes in! Use forEach() to check each value in your list and returns list of Boolean values

3

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.