Multi-Row Variable datapills greyed out in Flow Designer

Rosemary4
Tera Expert

My personal dev instance is on Rome. I'm trying to use the value from one of the columns of a multi-row variable set in a For Each loop to lookup the sys_ids in sys_user. The steps I've take are:

1) Get Catalog Variables from the Catalog Item in question

2) Add a For Each using the Array.Object from Step 1

3) Perform a Look Up Record

Bot the String for the column in the Array Object and the Item in the For Each loop are greyed out and unable to be selected.

Have I missed something obvious?

find_real_file.png

1 ACCEPTED SOLUTION

Rosemary4
Tera Expert

If anyone encounters this problem in future, the steps to resolve are:

  1. Save your Flow
  2. Type "cache.do" in the filter navigator and hit enter
  3. Wait for the information screen to display
  4. Refresh your Flow Designer tab

    The datapill in the "For Each" loop is now available for use

View solution in original post

7 REPLIES 7

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

you possibly need to convert that string of approvers to an array and then use For Each

refer my blog for the same

Using list collector in Flow Designer 'For Each loop' by converting string into array of string

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

thanks for the suggestion but my understanding from researching various communities threads about this today is that your solution is more appropriate for pre-Paris release.

what I'm trying to do on the Rome platform should be supported functionality and so I'm seeking advice on whether I have taken a wrong step somewhere to achieve this outcome.

Hi,

approvers variable is MRVS or list collector type?

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

@Rosemary 

Seems it's an issue in Rome which few members also reported

It was working fine in earlier versions

How to use multi row variable set with Flow designer

find_real_file.png

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader