Hello! I need support to execute an action within Power Automate.
I need to create a flow where when I attach an Excel file to a specific group, a private message is sent to the users listed in the file.
The file is composed of (Column "A": User's full name; Column "B": Messages to be sent).
I'm having trouble extracting the name from column "A" and transforming it into a user ID to send the message privately, because the flow loops and doesn't trigger the message to the users.
Can you help me with a way to extract the names and transform them into Teams User IDs?
When you meant file attached to a group- what does it actually meant ?
Also it is better if you have user's email id in column A rather than their full name as email can serve as unique identifer for person and does not need to find the id of the user as power automate ms team action does not need to know user id of person to send teams message as they use person's email id
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!
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Share
Report
All responses (
Answers (
18,129
