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 / Create one and only on...
Power Automate
Answered

Create one and only one approval with different items on sharepoint

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hello everyone !

 

I need your help about my flow on power automate. Indeed, I created a power apps, which registers extra hours.the date of week ,when the employee takes extra hours (Extra Hours & date of the week are on a repeating table), with the manager name (who validates extra hours), the name of the employee.

 

These information are registered into a sharepoint list. Each item (line) on this sharepoint list represents a week of extra hours.

 

After this, I created, on power automated, a flow, which triggers when an item on sharepoint list is created or modified. When it triggers, it creates an approval for the manager. However, it creates an approval for each entry we created, with the help of the repeating table.

 

My main question is : Is there a way to create only one approval with a few items, which are in link with a value in a column on a sharepoint list (such as the name of the employee) ?

 

Thanks for your help !

Categories:
I have the same question (0)
  • Verified answer
    murshed Profile Picture
    Microsoft Employee on at

    I am assuming you are using a flow that looks something like this: https://docs.microsoft.com/en-us/power-automate/trigger-sharepoint-list

    After you create an approval instead of sending the email save the approval information in a database (Excel can be used too). Create a second flow that runs every hour and picks up the item from the database (or the Excel file) and sends a digest using the information about the approvals. Then delete the sent items from the database.

    If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION ☑️. If you find this reply helpful, please consider giving it a LIKE 👍.

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Thanks for your answer.

     

    Indeed I selected a model like this. It was "Start an approval in teams when a sharepoint list is modified".

     

    However, I need more details. My main goal is to create an approval in link with one person who fill in a form on Powerapps. However, when a lot of people answer at the same time this form, it could make a trouble, couldn't it ?

     

    Do you have details or a link with a topic how to create this excel table ?

     

    Thanks a lot for your help and really sorry for the disturbing.

     

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

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 241 Super User 2026 Season 1

#2
11manish Profile Picture

11manish 179

#3
Haque Profile Picture

Haque 159

Last 30 days Overall leaderboard