thank you for your reply.
could you please help/guide me on my below requirement...
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 parent business owners from the folder structure when there is a file created only in a child 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 only to Sub Folder B.
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 |
Folder A | Sub Folder A1 | Sub Folder A2 | Email Trigger | |
When an new file is added | N | N | Email only to Folder A business Owner | |
| When an file is created in Sub folder A1 | N | Email only to Sub Folder A1 Business Owner | |
I have tried to achieve this by creating an Custom List on Share point where Custom List has all folders and sub folders with their corresponding business owner email id’s. I had created an file in sub folder A1 and I tried to filter the sub folderA1 from Custom List ,I am not finding any function to retrieve sub folder A1 from folder path and use that as a filter condition to filter custom list.
Could you please guide me what I am missing and also help me with the solution ?