cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Veblitz
Post Prodigy
Post Prodigy

Notify email users from another list

When item is created in Main list using PowerApps by clicking SubmitForm(newform ),then I need to send email to list of users from Approvers list whose Title=HR

 

List schema:

Main list 

Name  status

John     Inpending

 

Approvers List

 

Title(singleline)     Name(person field with allow multiple selections enabled in column settings)

HR                          Mathew; Joe; Jim

CEO                         carol

1 ACCEPTED SOLUTION

Accepted Solutions
abm
Super User
Super User

Hi @Veblitz 

 

Follows the below steps

 

image.png

 

image.png

 

Above Parse JSON schema is as follows:

 

{
    "type""array",
    "items": {
        "type""object",
        "properties": {
            "@@odata.type": {
                "type""string"
            },
            "Claims": {
                "type""string"
            },
            "DisplayName": {
                "type""string"
            },
            "Email": {
                "type""string"
            },
            "Picture": {
                "type""string"
            },
            "Department": {},
            "JobTitle": {}
        },
        "required": [
            "@@odata.type",
            "Claims",
            "DisplayName",
            "Email",
            "Picture",
            "Department",
            "JobTitle"
        ]
    }
}
 
 
image.png
 
Finally the compose2 will have all the approver emails. Next step you can add your approver actions steps.
 
Thanks


Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

View solution in original post

2 REPLIES 2
abm
Super User
Super User

Hi @Veblitz 

 

Follows the below steps

 

image.png

 

image.png

 

Above Parse JSON schema is as follows:

 

{
    "type""array",
    "items": {
        "type""object",
        "properties": {
            "@@odata.type": {
                "type""string"
            },
            "Claims": {
                "type""string"
            },
            "DisplayName": {
                "type""string"
            },
            "Email": {
                "type""string"
            },
            "Picture": {
                "type""string"
            },
            "Department": {},
            "JobTitle": {}
        },
        "required": [
            "@@odata.type",
            "Claims",
            "DisplayName",
            "Email",
            "Picture",
            "Department",
            "JobTitle"
        ]
    }
}
 
 
image.png
 
Finally the compose2 will have all the approver emails. Next step you can add your approver actions steps.
 
Thanks


Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials
Veblitz
Post Prodigy
Post Prodigy

Thanks a lot.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (4,685)