Unanswered

How to read text from a Teams message posted via an incoming webhook

(0) Share

Report

Posted on by CU-19081228-9

Hello Everyone.

We have set up Site24x7 alerts to a Teams channel.

Whenever a message is posted that mentions 'down' or 'DOWN' I want to post a reply message automatically.

Right now, here is my flow:

1 - Wait for a new message to be posted and then get the HTML from the message body.

2 - Set up a condition that looks for 'DOWN' or 'IS DOWN' inside the HTML body output from step 1 and then does something.

Will this work? Or do I need to do something else?

Kind regards.

Categories:

Building flows

I have the same question (0)

All responses (11)

Answers (0)

Sort by

VictorIvanidze 13,081 on at

Like (1)

Report
Copy link

Link copied!

As the subject line contains "is down" you can analyze only Subject.

Was this reply helpful? Yes No
CU-19081228-9 on at

Like (0)

Report
Copy link

Link copied!

Thank you so much for replying @VictorIvanidze

What if the Teams message is actually an attachment? How can I read that for certain data and do something?

Like this?
I just want to be able to read the contents of the message posted via an incoming webhook, that Teams puts in an attachment (shown above) and then perform an action.

E.g. the data in the attachment is data in tabular format. I want to be able to do something if the data in one particular column contains or exceeds a certain value.

For example, if the data in the attachment looked like this:

Shop Number of Customers Profit
1 10 100
2 5 10

If 'Profit' <= 10 then do something...

I just don't know how to extract the actual content of the message posted to Teams because it doesn't seem to have stuff like Subject/Body etc.

Many thanks for any help you can kindly give.

Was this reply helpful? Yes No
CU-19081228-9 on at

Like (0)

Report
Copy link

Link copied!

Thank you for replying @VictorIvanidze

How about if the message put into Teams via a third party looks like this?

How can I extract that information and then do something with it?

My flow looks like this:

1 - Get message details from Teams for new message posted - triggerOutputs()?['body/body/content']
2 - Parse JSON using the output from step 1.
3 - Use a Compose - body('Parse_JSON')?['attachments'][0]['content']

What is the next step to get data that I can action upon?

E.g.

If that data, when posted to Teams, looks like this:

Shop Customers Profit
1 10 100
2 2 5

How can I 'read' the data so that if 'Profit' <= 10 then do something?

Many thanks for any help you can give.

Was this reply helpful? Yes No
VictorIvanidze 13,081 on at

Like (1)

Report
Copy link

Link copied!

You have to convert a HTML table to a JSON array.

Was this reply helpful? Yes No
CU-19081228-9 on at

Like (0)

Report
Copy link

Link copied!

Thanks for replying @VictorIvanidze - how is that done if I only have the attachment ID as content, as shown in the above screenshot?

I assume that once I have that I can then follow your instructions above.

Was this reply helpful? Yes No
VictorIvanidze 13,081 on at

Like (0)

Report
Copy link

Link copied!

It's unclear for me if you can retrieve the content of the attachment or not.

Was this reply helpful? Yes No
CU-19081228-9 on at

Like (0)

Report
Copy link

Link copied!

@VictorIvanidze

Right now, I just get this:

I don't know how to retrieve the content of the attachment, but that is what I would like to do - is it not possible?

Many thanks.

Was this reply helpful? Yes No
Amit_Sharma 1,569 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @ianwuk
Could you show me whole text which return in content property.

Was this reply helpful? Yes No
CU-19081228-9 on at

Like (0)

Report
Copy link

Link copied!

@Amit_Sharma - Sent via a PM.

Alternatively, can my cloud flow somehow read the text of the message posted to the Teams channel using OCR and then do something that way?

Thanks.

Was this reply helpful? Yes No
Tarik101 2 on at

Like (0)

Report
Copy link

Link copied!

sorry for responding to an old post but were you able to find a solution to this? @ianwuk

Was this reply helpful? Yes No