Unanswered

Post a message to Teams when a new item is added to a Sharepoint List With Conditions

(1) Share

Report

Posted on by CU05082214-0

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?

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

v-yetonggu-msft on at

Like (1)

Report

Hi @BelindaH ,

Is your location column a multiple-choice column?

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
CU05082214-0 50 on at

Like (1)

Report

No, it is a single choice column.

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (1)

Report

Hi @BelindaH ,

Please check this test:

Flow Preview:

Flow Configuration:

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
CU05082214-0 50 on at

Like (1)

Report

Thank you! I will test first thing tomorrow

Was this reply helpful? Yes No
Verified answer

CU05082214-0 50 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (1)

Report
Hi @BelindaH ,

Please check this test:

SharePoint List:

Flow Preview:

Flow Configuration:

@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

Was this reply helpful? Yes No
CU05082214-0 50 on at

Like (1)

Report

Thanks. I was able to get it to work this way.

Was this reply helpful? Yes No