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.