web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Sharepoint list to sen...
Power Automate
Unanswered

Sharepoint list to send an email from it after creating flow from power automate

(0) ShareShare
ReportReport
Posted on by
We have a SharePoint list used as a client visit report where Account Managers (salespeople) input their visit details. There are 6 salespeople divided into two groups, each group reporting to one of two managers (3 salespeople per manager). Here are the requirements for list access and functionality:
  1. Each manager should be able to view only the rows submitted by their respective salespeople.
  2. Each salesperson should be able to view only their own submitted rows and not those of other salespeople.
  3. Additionally, there is a Sales Support Associate who will be responsible for arranging samples upon request. Salespeople will enter her name in a designated column if they need her assistance, and this action should trigger an automatic email notification to her directly from the list. This email notification should also be triggered if the salespeople assign tasks to other team members, such as those in the Supply Chain, Executive, or Customer Service departments.We have a SharePoint list used as a client visit report where Account Managers (salespeople) input their visit details. There are 6 salespeople divided into two groups, each group reporting to one of two managers (3 salespeople per manager).
i created a flow and its works for 1 hour then i made a change in the sharepoint list then its not working and this is the Error message  
 
ExpressionEvaluationFailed.
The execution of template action 'Apply_to_each' failed: the result of
the evaluation of 'foreach' expression
'@outputs('Get_item')?['body/field_7']' is of type 'Object'. The result
must be a valid array.
 
can you help to fix this error 
Categories:
  • Ramiz Profile Picture
    245 on at
    Hi,

    Kindly share your flow steps. By looking at the error, apply to each requires an array to loop through all items but you are passing an object instead of an array.

    You can open the failed flow and the success one as well and compare the input of Apply to Each action.

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 355

#2
11manish Profile Picture

11manish 336 Super User 2026 Season 2

#3
M Bilal Khan Profile Picture

M Bilal Khan 308

Last 30 days Overall leaderboard