50
I have a flow that starts with When an item is created in a Sharepoint list, then I have Post a Message in a Teams chat or channel. I want to add a condition that the Teams message is only sent when the "Location" column contains one of several different values. I added the condition, but it is not sending the message in Teams anymore. What am I doing wrong?
Thanks. I was able to get it to work this way.
Hi @BelindaH ,
Please check this test:
SharePoint List:
Flow Preview:
Flow Configuration:
Share
Report
All responses (
Answers (
@Or(contains(if(empty(item()?['Location/Value']),'',item()?['Location/Value']), 'DFW'),contains(if(empty(item()?['Location/Value']),'',item()?['Location/Value']), 'IOC'),contains(if(empty(item()?['Location/Value']),'',item()?['Location/Value']), 'TOL'),contains(if(empty(item()?['Location/Value']),'',item()?['Location/Value']), 'ORD'),contains(if(empty(item()?['Location/Value']),'',item()?['Location/Value']), 'DFW-HGR'))
length(body('Filter_array'))item()?['CompanyNumber']
item()?['FinalMeetingDate']
item()?['MeetingFrequency/Value']The Result:
Best Regards,
Sunshine Gu
Unfortunately, it did not work for me. Any time I add conditions to a flow, the flow will not work for some reason. I wanted to filter the items to only receive the Teams message for the above locations, but I finally just set the flow to send the message for all newly created items in the SharePoint list.
Thank you! I will test first thing tomorrow
No, it is a single choice column.
