Skip to main content

Notifications

Announcements

Replay: Power Platform Community AMA - Copilot Studio | April
Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Using Flows / Targetting a slack use...
Power Automate - Using Flows
Unanswered

Targetting a slack user with dynamic content from Sharepoint

(0) ShareShare
ReportReport
Posted on by thomasando 6

Our company has a calendar in Sharepoint online which we use as a roster - a different person is rostered to do something each day. The calendar has a 'who' field which looks up from our company directory. 

 

I'm playing around with the Slack connector and it's working great if I hard code in the user. I'd like though to be able to specifically target a user for notification based on their 'who' field. All users in our company have a slack account (provisioned via SAML from Azure AD) and the slack handle for each user exactly matches the email prefix (eg. someuser@company.com has a slack handle of @someuser).

 

Does anybody have any suggestions of how to do this?

 

To sumarise - I want to assign the calendar entry to Fred, and the flow should send a private message via Slack to @fred - so I need to pull the username dynamically.

 

Many thanks!

Categories:
General Questions
  • Lance_Raeper Profile Picture
    Lance_Raeper 6 on at
    Re: Targetting a slack user with dynamic content from Sharepoint

    I know this is an old thread, but I wanted to link my solution here because there is still no user search in the official Slack connector as of March 2024, and we NEED this. The Slack API provides a method to search and return user profile data. I built a custom connector around it, which takes an email address as input and returns associated Slack profile data, including the Member ID, which you can use as 'Channel Name' in the Post message (V2) action.

     

    I posted a step-by-step guide here on LinedIn. Please give me a thumbs up if this helped you! 🙂

    Lance_Raeper_0-1710099713569.png

     

  • thomasando Profile Picture
    thomasando 6 on at
    Re: Targetting a slack user with dynamic content from Sharepoint

    Yeah I couldn't work out how to do it so I came up with a workaround.

     

    I've set up a Sharepoint workflow (triggers on new item) to figure out what the Slack username is based on the email address and write it back to the list item. I set the flow to run when an entry is changed. The workflow also sets a couple of other things, including a condition which I use within the flow to determine if it should act or not.

     

    Not ideal really, to have two different processes hanging together to do something seemingly basic, but it works well.

  • Leo09 Profile Picture
    Leo09 212 on at
    Re: Targetting a slack user with dynamic content from Sharepoint

    That is a resonable request yet it's not possible in flow to pull the username dynamically. I think?

     

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.

Helpful resources

News and Announcements

Replay: Power Platform Community AMA - Copilot Studio | April
Welcome to the Power Platform Communities

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,708 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,030 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow

Product updates

Microsoft Power Platform Community release plans