Answered

How to send messages in Teams only if you create an HTML table

(0) Share

Report

Posted on by Patricia11

Hello all,

I would like to create an HTML table in Excel on SharePoint and post a message in Teams only when both conditions A and B below are met.

Condition A: Create an HTML table only for rows where a specific column in Excel is blank and other columns are filled in.
Condition B: When a specific user updates Excel(specify user's email address)

I've built a flow, but messages are posted in Teams even if the HTML table is not created.

Also, when I tried setting condition A using the "Condition" flow, Apply to each was automatically inserted and a large number of Teams messages were posted.

Could you please let me know if there is a solution?

The flow I built and the message posted to Teams are below.

Message posted to Teams when HTML table is created

Message posted to Teams when HTML table is not created (I would like to prevent this message from being posted)

Any guidance would be much appreciated.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

v-yueyun-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi , @Patricia11
Do you mean you when you "Select" action return null , you do not want to post the message to Teams?
If this , you can use this condition in your side:

length(body('Select'))

If I misunderstand what you mean, you can describe your needs and your expected outcomes in detail so that we can better help you. If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
Patricia11 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-yueyun-msft ,

Thank you for your reply.

I don't want the message to be posted to Teams when the "Select" and "Create HTML Table" actions return the image below.

When I added "length(body('Select'))" to the condition, the following error message was displayed and I was unable to save the flow.
"Saving flow failed with code 'InvalidTemplate' and message 'The template validation failed: 'The action(s) 'Select' referenced by 'inputs' in action 'condition' are not defined in the template.'.' .”

Could you please tell me how to solve this problem?
I apologize for the inconvenience, but I would appreciate your guidance.

Was this reply helpful? Yes No
v-yueyun-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi , @Patricia11
You need to update the action name in your side.
Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
Patricia11 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-yueyun-msft ,
Thank you for your detailed explanation.
I was able to successfully build the flow and successfully tested it.
Thank you very much for your help.

Was this reply helpful? Yes No