Power Platform Community Forum Thread Details

Hi :)

I have a flow in PA that sends a message in Teams to alert a group chat if a new request has been submitted (trigger : when response is received in MS Form, create new item in SP List then send Teams message).

I would like to know how to / if it's possible to get the email(or profile) of the employee/user that did the first thumbs up on the message in teams, and then autopopulate the specific item in the List with the employee's email in the field 'Assigned to'.

In other words : when an employee does a thumbs up on the Teams message in the group chat, this employee is automaticly assigned to the related item.

My way of doing it would be to create an other flow that when a new message is submitted in teams, every 30 secondes check if there has been a liked reaction on that message. If so, condition » true. But then.... I dunno what to do to retreive the User that did the reaction.

Thank you ++++

(PS : My first language is french ;) )

Categories:

Building flows

Hi @Audrey2

Yes its possible on how to find the user who reacted to the message.

See below flow which helps to figure out who is the user behind a like reaction on message.

Steps

1. Use graph api to get all chats using send a microsoft graph http request action.

2. Next use filter array action to get specifc chat based on its title, in your case it would be Group title, in my case group title is Test Groupchat

Expression:

body('Send_a_Microsoft_Graph_HTTP_request_2')?['value']
 
3. use another send http request which retrives all chat messages from that chat using id parameter.
 
4. Use a filter array action which filters the chat message whether they have required content, so that we can figure out the expected chatmessage.
Expression: body('Send_a_Microsoft_Graph_HTTP_request')?['value']
 
5. Using above filter's output, use the data to find whether it have any like reaction.
 
Expression: 
first(body('Filter_array_2'))?['reactions']
 
Now the output of filter array would have specific reaction details, in that detail- there is an id attribute which would be user's id, use that get user's profile to get users details.
Expression: 
first(body('Filter_array_3'))?['user/user/id']
 
The output of this action would have all details of user which you can to update the item in sharepoint for assigned to column.
 
Hope this helps !
Thanks & Regards,

Nived N
Stay connected:

LinkedIn | YouTube | Blogs
Was this answer helpful?

If yes, please mark it as the solution by selecting the checkbox in the discussion thread.

Your feedback motivates me to keep contributing. Thank you!