cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Pinoq
Helper IV
Helper IV

Send an email that can show the existing item.

I am now creating a new share point portal that save the record of some new join staff. I have created an approval flow with some notification email to HR staff, But I have 2 flow that I cannot figure out how to config.

 

1) When the record of an existing staff change: When the record of an existing staff change , I would like to send an email to the staff to ensure the record is correct. I know how to set an approval flow. But the problem is that, for record change , I would like to send an email to include both the new record and the existing record. Please advise how can I pull the record of the existing staff.

 

2) I have some HR staff that are responsible for approve the new staff record and I have created a list for them, please advise if how I can create a flow each time a add a staff in the staff list , they are get the permission of approval?

 

2 REPLIES 2
ChristianAbata
Super User II
Super User II

@Pinoq  shure you can try this triggers to to what you need.

 

To send an approval when a new user is inserted in your list

create1.PNG

 

To update your list when a user is out.

create2.PNG



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA
mimisek
Frequent Visitor

Hi Pinoq,

Here's the steps:

 

1) You have to enable versions on your list setting via SharePoint.

2) Add "When an item is created or modified" as a trigger

3) Add Initialize variable, name it "version"

   set it to integer / set the formula : int(triggerBody()?['{VersionNumber}'])
image.png

4) Add "Initialize variable" again and set it to String/ formula : add(variables('version'),-1)

   and add ".0" to last of the value 

image.png

5) Add "Send an HTTP request to SharePoint"

  URI : _api/web/lists/GetByTitle('<Your list name>')/Items(@{triggerBody()?['ID']})/Versions

image.png

 

6) Save the flow and do Test

7) Copy whole "Body" in the output of "Send an HTTP Request to Sharepoint"

image.png

 

8 ) Get back to the flow editing page

9) Add "Parse JSON", input "Body" from "Send an HTTP...." with dynamic content

    Click "Generate from sample" and paste what you copy in step 7, and click "Done"

image.png

10) After this, consist as below

image.png

 

Whole flow construction:

image.png

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (81,015)