web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Trigger condition with...
Power Automate
Unanswered

Trigger condition with SharePoint mutli-select choice column

(0) ShareShare
ReportReport
Posted on by 95

Trigger is when a SP list item is created or modified.

I'm trying to create a trigger condition for a SP list choice column which can have multiple selected choices.

 

 

 "NotificationStatus": [
 {
 "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
 "Id": 0,
 "Value": "New"
 },
 {
 "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
 "Id": 1,
 "Value": "Pending"
 }
 ]

 

 

The output from the triggerbody might looks like above.

How can I create a "contains" condition?

 

 

@contains(join(triggerOutputs()?['body/NotificationStatus'],';'),'New')

 

 

I can do the above, but this isn't very elegant. as it turns the object into a text string then sees if it contains New as a substring.

 

I can foresee some issues with this. Like what if one of the choices is SharePoint, since that's always going to be in the string due to #Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference

 

 

["New","Pending"]

 

 

Is there a proper way to get the above array from the original object and use the contains function on this array instead?

Yes, I've got something that seems to work. But want to know the proper way.

Categories:
I have the same question (0)
  • v-litu-msft Profile Picture
    on at
    Re: Trigger condition with SharePoint mutli-select choice column

    Hi @JohnMacDougall,

     

    You could initialize an array variable and append these multiple-choice value into the variable, then use Condition action to check if the variable contains the specified value:

    Screenshot 2021-03-17 105541.jpg

     Screenshot 2021-03-17 105835.jpg

     

    Best Regards,
    Community Support Team _ Lin Tu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Verified answer
    JohnMacDougall Profile Picture
    95 on at
    Re: Trigger condition with SharePoint mutli-select choice column

    I feel really bad, as I didn't realise I somehow I made two of the same post. Not sure how that happened. ☹️

     

    https://powerusers.microsoft.com/t5/Building-Flows/Trigger-condition-with-SharePoint-mutli-select-choice-column/m-p/860871#M120708

     

    I was able to get the answer in the original post.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 497 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 477 Super User 2025 Season 2

#3
chiaraalina Profile Picture

chiaraalina 242

Last 30 days Overall leaderboard