Power Platform Community Forum Thread Details

Dear All,

I would like to extract all the names of the creators of pending request and send them updates about the status of their request which is stored in SharePoint.

I am trying to do something similar (i guess identical 🙂 ) to what has been explained here

https://spodev.com/task-reminders-microsoft-flow-and-sharepoint/

Please note that since i am using the Created By field ( we cannot keep this as a multiselect column as required by the above post)

Formulas that i am using:-

Append to array variable

first(items('Apply_to_each')?['Author'])?['Email']

Initialize Emails

union(variables('EmailArray'), variables('EmailArray'))

Filter Array 2

first(item()?['Author'])?['Email'] equal to first(variables('Emails'))

Here i am getting the following error

Unable to process template language expressions in action 'Append_to_array_variable' inputs at line '0' and column '0': 'The template language function 'first' expects its parameter be an array or a string. The provided value is of type 'Object'.