Power Platform Community Forum Thread Details

Hi Power Automate Community,

Am totally new to Power Automate. We have been given a requirement to create a flow which can help us to take the content from email attachments and update the data into excel sheet in Share Point and send an approval mail when new rows added in sheet.

Below is the requirement we are looking for.

1. We have an Excel sheet where we document Access exception in different applications.

2. When an email with attachment received in Inbox, if the attachment headers match with our master sheet headers that attachment data needs to be added into our master excel sheet in Share Point.

3. So once new Rows added to sheet, for every new row that has been added we want to trigger two approval mails one to the Manager Email id (mentioned in the master sheet) if Manager approves then another mail to the licensing team (which is common email Id). If both approves the status column should be updated as approved.

4. If anyone reject the request that Row needs to be deleted from the sheet and send a rejection email to user email id mentioned in the sheet.

5. If no one responds to approval mail it should make three attempts of sending reminder after every 24hrs. Even after three reminders if response the row should be removed and send a rejection mail to the user email of that particular row.

I have tried multiple use cases from Power Automate community. But nothing helps me that much. Can someone please guide me which triggers I have to use for creating the above Flow?

Thanks in Advance😊

Categories:

Building flows