News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows send email

Power Automate - Building Flows

Answered

send email

(0) Share

Report

Report

Posted on by Veblitz

2,059

I need to send email lookup from Access list approvers when a file status is approved

Categories:

Business Process Flows

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Expiscornovus 30,706 on at

Like (1)

Report
send email to approvers list

For the lookup you can use a Filter Query in a Get Items field. For that Filter Query you can use the Folder Path property and split on the '/' character.

I assume the first level of your library looks like the below, correct?

In that case you can always use the second item with the below OData filter

split(triggerBody()?['{Path}'], '/')[1]

Happy to help out 😁

I share more #PowerAutomate and #SharePointOnline content on my Blog, Bluesky profile or Youtube Channel

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Announcing Mentions and Quick Responses!

Give Back to the Community this Month

Join us in the Community for an AMA: December 12th Register Today

Quick Links

Leaderboard

#1

WarrenBelz 143,591

#2

RandyHayes 76,308

#3

Pstork1 64,090

Leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans