web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate send email

Power Automate

Answered

send email

(0) Share

Report

Report

Posted on by Veblitz

2,249

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

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Expiscornovus 33,501 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No

Join the conversation