Requirement:
Share Point has multiple folder structure with nested folder in it and each folder has a group of users and one business owner for the complete folder structure. (Shown in the example below)
I need to implement a flow which triggers an email notification to its corresponding business owners requesting to Approve/Reject when an item/file is created in a folder/sub folder.
Once Approved/Rejected I would need to update the file status on the SharePoint based on the response to the email.
How do i achieve and specify folder specific business owner emails in the flow.
Implemented:
I have implemented a flow which sends an email when an item/file is created in any of the folder and status is also updated on the SharePoint as per the email response.
Road block: An email is triggered to all the business owners from the folder structure when there is a file created in only 1 folder where it is supposed to send an email to that particular business owner when/where a file/Item is created.
Ex: My issues in the below scenario
1) The email to business owner A only when the file is created in Folder A and Sub folder B, where as it is supposed to send the email to Sub folder B as well.
2)If we create a file in Sub folder C then the email should only be sent to Business Owner C and not to anyone else.
Folder A (Business Owner A)
File 1
Sub folder B (Business Owner B)
Sub folder B File 1
Sub folder C (Business Owner C)
Sub folder C File 1
