Unanswered

add guest member to an Office 365 Group

(0) Share

Report

Posted on by mobilismexico

261

My goal is to add an external email address as a Guest member to an Office 365 Group. I need help transforming the email address string to the form user_domain#tenant.onmicrosoft.com.

Say for example that my guest's email address is john@msn.com.

I have confirmed that the Add member to group block allows to add john_msn.com#EXT#contoso.onmicrosoft.com to an Office 365 Group in the Contoso tenant, as follows:

So far I have been able to assign john to a string variable with these blocks:

I know that I can obtain the domain string by simply extracting a substring starting from character @ for a length of total length minus "@position". This is where I'm stuck. From there I would only need to append my substrings in the right order:

user_domain#EXT#tenantconstant.onmicrosoft.com

What expressions should I use inside what blocks to accomplish this?

Thank you in advance!

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Mitanshu 1,650 Moderator on at

Like (0)

Report

You can use replace function/expression to change @ symbol in original email to _
so john@msn.com will become john_msn.com.
From here concatenate the rest of your static string using the Concat function/expression.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up

Was this reply helpful? Yes No
mobilismexico 261 on at

Like (0)

Report

hi @happyume ,
how exactly do I type the expression? I'm new to this. I tried this....
replace(mystringvariable, '@','-')
... and us.flow.microsoft.com said The expression is invalid.
What article would be a good starting point to learn how to use the expressions?

Was this reply helpful? Yes No
Verified answer

Mitanshu 1,650 Moderator on at

Like (0)

Report

replace(variables('original email'),'@','_')

concat(outputs('Compose'),'#EXT#contoso.onmicrosoft.com')

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up

Was this reply helpful? Yes No
Mitanshu 1,650 Moderator on at

Like (0)

Report

The most likely reason you got error is because Power Automate did not save your entire syntax. Try putting your cursor at the end of your expression and click update/save.

You can learn more from: https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference

If the content of this reply was useful, then please consider giving it Thumbs Up

Was this reply helpful? Yes No