Get email of page author

(0) Share

Report

Posted on by nonielb

I'm using Get files (proprieties only) to get the information of all pages in my Sharepoint. The idea is to email the author if page has not been modified in a while. However, I'm not able to ever get the author's email.

I have a loop for all pages in "Site Pages" and i'm trying to set author's email as @{items('for_each_page')?['Author/Email']}, but it returns NULL.

When I try a new loop using "Current Item" and then setting the variable as @{item()?['Email']} (Author Byline Email) it fails saying: The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@items('for_each_page')' is of type 'Object'. The result must be a valid array.

Long story short: I want the email of whoever create a certain page.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

tom_riha 10,185 Most Valuable Professional on at

Like (2)

Report
Re: Get email of page author

Hello @nonielb ,

the expression you use is correct:

@{items('Apply_to_each')?['Author/Email']}

but there might a be a problem if the page was created by an account that doesn't exist anymore - I think that they won't return anything.

Was this reply helpful? Yes No
Pstork1 68,678 Most Valuable Professional on at

Like (2)

Report

Re: Get email of page author

Double check your sitepages library. A lot of the pages will be authored by the System Account. It doesn't have an emial.

Was this reply helpful? Yes No