cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ALEXANDERIII
Level: Powered On

One email to approve many items from the SharePoint List

Hello, everyone,

 

I am looking if it is possible to send one Approval email to approve multiple items.

 

For example, I want a manager to choose to which software an employee should have an access.

 

I have a Sharepoint list, the key is Employee and it has 3 columns representing software. The initial value for each column is No.

 

So I want a manager to receive One approval email asking to approve/reject access to these 3 systems.

 

Then I plan to record it to Sharepoint. Is it possible?

2 REPLIES 2
Community Support Team
Community Support Team

Re: One email to approve many items from the SharePoint List

Hi @ ALEXANDERIII,

Thank you for posting.

 

 

Could you show more about configuration of your sharepoint list?

I have create a new sharepoint list, it have five column as sceenshots below:

 1.jpg

Title is a default column,

The type of Software1, Software2, Software3 is“Yes/No”, those field’s Default value set to “No”.

The type of Employee is “Person or Group”, In the More options of Column settings, I set the “Require that this column contains information” and “Enforce unique values”  to “Yes”.

as your referred in your post, the Employee field is the key of the list, so this field must have value and the value is required to be unique.

 

I have made a test on my side, you could refer to workaround below:

  1. Add a trigger “When an item is created”, fill in your Site Address and List Name.
  2. Add action “Start an approval”, select the Approval type, fill in the Title and Assigned to Field, you could fill in the Link to item dynamic content of trigger “When an item is created” in the “Item link” Field, fill in the Title dynamic content of trigger “When an item is created” in the “Item link description” Field.
  3. Add a Condition, the first value set to the Response dynamic content of “Start an approval” action , the second value set to “Approve”, the condition in the middle select is equal to.
  4. Inside the If yes, Add action “Update item”, fill in your Site Address and List Name, fill in the ID dynamic content of trigger “When an item is created” in the “Id” Field, fill in the Title dynamic content of trigger “When an item is created” in the “Title” Field
  5. The field of Software1, Software2, Software3 set to Yes.

 

Image reference:

 2.jpg

 

The flow run successfully as below:

 

3.jpg

 


Regards,
Alice Zhang

ALEXANDERIII
Level: Powered On

Re: One email to approve many items from the SharePoint List

Dear @v-yuazh-msft

 

Thanks a lot for your reply, it helps, but helps partially and here is why:

 

I wanted to be able to see a list of items as Software1 Software2 Software3 and approve them in one email but separately, meaning that I might want to approve access to Software1 but not Software2.

 

But using your solution and just an email instead of the approval I can send a direct link to the item to a specified person, so they would be able to see the options and check them in SharePoint list view.

 

 

Helpful resources

Announcements
firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (4,138)