- Each manager should be able to view only the rows submitted by their respective salespeople.
- Each salesperson should be able to view only their own submitted rows and not those of other salespeople.
- 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).
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.

Report
All responses (
Answers (