SOLVED

Insert edit list item URL into email body

%3CLINGO-SUB%20id%3D%22lingo-sub-35071%22%20slang%3D%22en-US%22%3EInsert%20edit%20list%20item%20URL%20into%20email%20body%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-35071%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20it%20possible%20to%20insert%20a%20link%20in%20the%20email%20body%20to%20edit%20the%20current%20SharePoint%20list%20item%20in%20a%20flow%20email%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-35071%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-310417%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Insert%20edit%20list%20item%20URL%20into%20email%20body%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-310417%22%20slang%3D%22en-US%22%3EIf%20you%20mean%20a%20PowerApp%20to%20edit%20data%20then%20you%20can%20pass%20parameters%20to%20the%20PowerApp%20in%20the%20querystring%20of%20the%20PowerApp%20sharing%20link%20such%20as%20the%20list%20item%20ID.%20In%20PowerApps%2C%20check%20in%20onStart%20if%20Param(your%20parameter)%20is%20empty%20of%20not%20and%20if%20it%20isn't%20navigate%20to%20a%20screen%20with%20and%20edit%20form%20and%20show%20the%20record%20with%20the%20ID%20matching%20your%20Param.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-310369%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Insert%20edit%20list%20item%20URL%20into%20email%20body%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-310369%22%20slang%3D%22en-US%22%3E%3CP%3EIt's%20the%20ID%20of%20the%20associated%20list%20item%20in%20the%20SharePoint%20list.%20You%20fetch%20it%20by%20adding%20dynamic%20content%2C%20ID%2C%20from%20the%20step%20in%20the%20flow%20that%20deals%20with%20that%20item.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-308630%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Insert%20edit%20list%20item%20URL%20into%20email%20body%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-308630%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20can%20we%20fetch%20the%20following%3A%3C%2FP%3E%3CPRE%3E%26lt%3B%26lt%3B%26lt%3BFLOW%20ITEMID%20TOKEN%26gt%3B%26gt%3B%26gt%3B%22%26gt%3B%3C%2FPRE%3E%3CP%3ECan%20you%20please%20provide%20more%20info%20on%20this%20part%3F%20I%20mean%20is%20this%20something%20that%20is%20going%20to%20behave%20Statically%20or%20dynamically%3F%20Also%20how%20can%20I%20fetch%20the%20Flow%20itemid%20token%2C%20Thanks%20for%20the%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-250743%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Insert%20edit%20list%20item%20URL%20into%20email%20body%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-250743%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20works%20if%20the%20EditForm%20is%20a%20SharePoint%20integration%20form.%20Is%20this%20as%20well%20possible%20if%20the%20App%20has%20been%20created%20from%20Data%20(which%20is%20as%20well%20a%20SharePoint%20list%2C%20but%20not%20integrated%20with%20customize%20forms)%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-57081%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Insert%20edit%20list%20item%20URL%20into%20email%20body%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-57081%22%20slang%3D%22en-US%22%3E%3CP%3EYES!%26nbsp%3B%20Thank%20you%20so%20much%20for%20posting%20this.%26nbsp%3B%20It%20works%20beautifully.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-35916%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Insert%20edit%20list%20item%20URL%20into%20email%20body%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-35916%22%20slang%3D%22en-US%22%3E%3CP%3EExcellent%2C%20thanks%20!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-35706%22%20slang%3D%22en-US%22%3ERE%3A%20Insert%20edit%20list%20item%20URL%20into%20email%20body%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-35706%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Ian%20Moran!%20There%20is%20no%20direct%20way%20at%20the%20moment%2C%20but%20you%20could%20craft%20your%20own%20link%20by%20using%20the%20ItemId.%20Make%20sure%20the%20mail%20is%20using%20HTML%20and%20then%20add%20something%20like%20this%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%3E%26lt%3Ba%20href%3D%22https%3A%2F%2Fcontoso.sharepoint.com%2Fteams%2Fmarketing%2FLists%2FIssueTracker%2FEditForm.aspx%3FID%3D%26lt%3B%26lt%3B%26lt%3BFLOW%20ITEMID%20TOKEN%26gt%3B%26gt%3B%26gt%3B%22%26gt%3BEdit%20item%26lt%3B%2Fa%26gt%3B%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Regular Contributor

Is it possible to insert a link in the email body to edit the current SharePoint list item in a flow email ?

7 Replies
best response confirmed by Ian Moran (Regular Contributor)
Solution

Hi Ian Moran! There is no direct way at the moment, but you could craft your own link by using the ItemId. Make sure the mail is using HTML and then add something like this:

 

<a href="https://contoso.sharepoint.com/teams/marketing/Lists/IssueTracker/EditForm.aspx?ID=<<<FLOW ITEMID TOKEN>>>">Edit item</a>

 

Excellent, thanks !

YES!  Thank you so much for posting this.  It works beautifully.

This works if the EditForm is a SharePoint integration form. Is this as well possible if the App has been created from Data (which is as well a SharePoint list, but not integrated with customize forms)?

How can we fetch the following:

<<<FLOW ITEMID TOKEN>>>">

Can you please provide more info on this part? I mean is this something that is going to behave Statically or dynamically? Also how can I fetch the Flow itemid token, Thanks for the help.

It's the ID of the associated list item in the SharePoint list. You fetch it by adding dynamic content, ID, from the step in the flow that deals with that item.

If you mean a PowerApp to edit data then you can pass parameters to the PowerApp in the querystring of the PowerApp sharing link such as the list item ID. In PowerApps, check in onStart if Param(your parameter) is empty of not and if it isn't navigate to a screen with and edit form and show the record with the ID matching your Param.