Answered

Power Automate Help

(0) Share

Report

Posted on by Dknight7

232

Hello, I am setting up an email trigger for my powerapp and im trying to use the value of a category in my data table, but it is a group field in my SP list. I get an error when I select manager group value and id. Here is the flow:

(power automate flow)

Screen Shot 2022-08-02 at 11.36.18 AM.png

(Sharepoint List)

Screen Shot 2022-08-02 at 11.55.07 AM.png

(When I click the manager group category)

Screen Shot 2022-08-02 at 11.55.25 AM.png

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Akash17 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Dknight7
In order to grab the email ids of your group member you can use action called 'send HTTP request to SharePoint list ' and it will return an array of mail and in order to grab your group id you can open your group and above in URL you can grab your group id number
Please refer
https://www.youtube.com/watch?v=574R1VrE57E
Thanks

Was this reply helpful? Yes No
Dknight7 232 on at

Like
a
(0)

Report
Copy link

Link copied!

I think this is it, but I need a step-by-step walkthrough. How can I point it to my specific SP list and the lookup column from which I am trying to retrieve the user groups? My apologies, I'm new to power automate and power apps. Here is what I have so far:

Was this reply helpful? Yes No
Dknight7 232 on at

Like
a
(0)

Report
Copy link

Link copied!

The way the guy has his SP list setup is different from the way mine is set up.

Was this reply helpful? Yes No
Verified answer

v-yujincui-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Dknight7 ,

Based on the information you provided, i have made a simple test for your reference.

Is the data structure of your two Lists similar to this?

If so, here is my flow. I extracted the group id from the 'Claims' field of the 'Person or Group' column, then added the 'List group members' action to get the emails of the group members.

last(split(outputs('Compose'), 'separator'))

Your 'separator' may be different from mine, you could find it in the run history.

Result Screenshot:

In addition, here is a link that for your reference.

https://powerusers.microsoft.com/t5/Building-Flows/Read-People-Group-field-from-a-Sharepoint-List-then-send-a-Teams/m-p/1647131#M183092

Best Regards,

Charlie Choi

Was this reply helpful? Yes No