Unanswered

Send an email that can show the existing item.

(0) Share

Report

Posted on by Pinoq

102

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?

All responses (2)

Answers (0)

mimisek 11 on at

Like (0)

Report

Re: Send an email that can show the existing item.

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}'])
4) Add "Initialize variable" again and set it to String/ formula : add(variables('version'),-1)
and add ".0" to last of the value
5) Add "Send an HTTP request to SharePoint"
URI : _api/web/lists/GetByTitle('<Your list name>')/Items(@{triggerBody()?['ID']})/Versions

6) Save the flow and do Test
7) Copy whole "Body" in the output of "Send an HTTP Request to Sharepoint"

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"
10) After this, consist as below

Whole flow construction:
ChristianAbata 8,949 Most Valuable Professional on at

Like (1)

Report

Re: Send an email that can show the existing item.

@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

To update your list when a user is out.