Flow: Send Email to SharePoint Group Members

You may also like...

9 Responses

  1. Jason Brownhill says:

    I think some people new to Flow might need to know the construct of the ‘For Each’ action to continue until the variable ‘i’ is equal to the count of results in the array/members of the group. Not sure how that looks without doing it myself, but nice article, thanks!

  2. Jason Brownhill says:

    Nice solution, but I took an easier way out and created a new Group, which then has an associated email address with it. Being short on time I didn’t have time to work on this one as well. A nice side feature is that I’m able to add that secondary group to the original site permissions. The only downside is the additional group/teams/planner/sharepoint site hanging around.

  3. Jason Brownhill says:

    Hi April,
    I’ve had to follow this solution due to a change in my Flow and the expressions above aren’t working for me. Are you able to validate these again please?
    Thanks,
    Jason.

  4. Ilie Toader says:

    Hey April,

    Mind if you provide me some assistance with the code you provided? I tried all your steps and when I try to run the flow, it displays “BadRequest. The variable ‘Users’ of type ‘Array’ cannot be initialized or updated with value ‘Body(“Parse_JSON”)[“d”][“results”]’ of type ‘String’. The variable ‘Users’ only supports values of types ‘Array’.” when setting the array variables from Users, found at step “Setting the User Object”

    Could you please send me an email and let me know what went wrong on my end?

  5. sukesh says:

    Hi April,

    I got the below error at the step set variable action

    BadRequest. The variable ‘Users’ of type ‘Array’ cannot be initialized or updated with value ‘body(“Parse_JSON”)[“d”][“results”]’ of type ‘String’. The variable ‘Users’ only supports values of types ‘Array’.

    can you help me out in here???

    Regards
    Sukesh

  6. Javier says:

    doesn’t work, get the error when setting the Variable…. Not sure what I’m doing wrong
    BadRequest. The variable ‘Users’ of type ‘Array’ cannot be initialized or updated with value ‘body(“Parse_JSON”)[“d”][“results”]’ of type ‘String’. The variable ‘Users’ only supports values of types ‘Array’.

  7. Jennie says:

    Does anyone know why when I try to recreate this Flow, on the step to Set Variable for Users after the Parse JSON step I get:

    BadRequest. The variable ‘Users’ of type ‘Array’ cannot be initialized or updated with value ‘body(“Parse_JSON”)[“d”][“results”]’ of type ‘String’. The variable ‘Users’ only supports values of types ‘Array’.

    Any help would be appreciated! Thank you!

  8. Stephen Huckaba says:

    I have this working thats. For those in thte comments with the string to array issue. the body(‘Parse_JSON’)[‘d’][‘results’] is expression language dont add it directly to the field. Choose the expression tab and enter it there.

  9. Hello, just wanted to tell you, I enjoyed this blog
    post. It was helpful. Keep on posting!

Leave a Reply

Your email address will not be published. Required fields are marked *