Filter Array syntax for a SharePoint choice field that allows multiple values

(0) Share

Report

Posted on by smorley

546

Hi everyone,

I could use some help.

I have a workflow the loops through a list looking for items that match today's date. It sends an email to the department administrator for all items in the list that matches the condition. It was working fine, until the customer asked that one of the choice fields be allowed to have multiple values.

The email that comes to the administrator does not display a Building any longer.

In addition, it also sends an email to the individual. I used a compose statement to set a variable for the details of that email.

Here are the results of the email.

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @smorley

I made a video based on this. Please have a look and comment.

https://youtu.be/80EGtZGP5DA

Thanks

Was this reply helpful? Yes No
smorley 546 on at

Like (1)

Report

@abm I can't believe you made a video. Thanks so much, it worked like a charm!

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @smorley

Glad to hear that all working.

Thanks

Was this reply helpful? Yes No
smorley 546 on at

Like (0)

Report

Sorry @abm I spoke to soon. In testing it, the workflow loops through the list and appends to string variable, all the records that match the condition.
Here's what the list looks like:
After the Get Items action, I added the Parse JSON and append to string steps like you suggested.

I think the Append to String Variable is in the wrong place.

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @smorley

Not sure your screenshots are in the right order. Could you please post a new screenshot of the full flow with the mappings. Right now I can't figure out the order.

Was this reply helpful? Yes No
smorley 546 on at

Like (0)

Report

Sorry @abm my snipping tool was misbehaving.
Screen 1
Screen 2
Screen 3
Screen 4
Screen 5
Screen 6
Screen 7
Screen 8

Was this reply helpful? Yes No