Announcements
I have a column role in SharePoint list which has User and Admin and I want my Send an email v2 to send email on all users that has User as role.
I already have set the email but just needs the filter.Anyone could help?
First of all you will use GetItems action of SharePoint to get the records. I am using OData query Role eq 'User' to filter records that have user role only
then i am using apply to each variable to send an email to all the records filtered. I am using the dynamic column value in to that i got from above function
Here is my SP structure
Please click Accept as Solution if it resolved your problem or give it a Thumbs Up if it helped you in anyway this will allow other people to search correct solutions effectively.
Thanks,
Rahber
@Rahber How will this be triggered? Is it possible if this will be triggered when a new item is created in sharepoint?
@Rahber This works but when I add new item in sharepoint it does run all the users who has User as Role.So If I added a new row it also sends an email to old rows.
You will use a condition then instead of Get Items.
1) When an item is created
2) Condition on user Role
3) If true send email
\
It worked!Thank you!
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
David_MA 273 Super User 2026 Season 2
trice602 149 Super User 2026 Season 2
11manish 144 Super User 2026 Season 2
