Unanswered

Targetting a slack user with dynamic content from Sharepoint

(0) Share

Report

Posted on by thomasando

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:

Using flows

I have the same question (0)

All responses (3)

Answers (0)

Leo09 212 on at

Like (0)

Report

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

Was this reply helpful? Yes No
thomasando 6 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Lance_Raeper 8 on at

Like (0)

Report

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! 🙂

Was this reply helpful? Yes No