Get Hyperlink from Sharepoint list element

[Anonymous]

Hello,

I have a sharepoint list. When a new Element is created I want to send an e-mail with the Hyperlink to the specific element.

Is that possible with MS Flow?

I checked the return of a list element but there is no hyperlink.

Kind Regards

Ramon

[v-monli-msft · Accepted solution]

Hi Ramon, 

About SharePoint list element, did you mean the SharePoint items? If yes, then in SharePoint, the hyperlink of the list item is like below, right?

If this is the link you want to get in Flow, then I think this cannot be done so far. As Flow doesn't contain the link of the list item in SharePoint dynamic content. 

You could post this idea in the Flow Ideas forum, so it might be considered for future releases.

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

Regards,

Mona Li

Regards,

Mona

[Anonymous]

Hello Mona,

Yes, we want that kind of Link to send within the flow. 

I posted the idea in the ideas forum, thank you.

kind regards

Ramon

[v-monli-msft]

Hi Ramon,

I just found a workaround for this case. You can inplace the URL ID part like this and it will get the new item's hyperlink:

Regards,

Mona

[Anonymous]

Hello Mona,

nice Workaround. This works!

Thank you.

kind Regards

Ramon

[Anonymous]

Hi Mona,

Can I get something similar for document link as well please? I have tried something but it will download the document but not sure how to create the link which can open the document. Any help will be greatly appreciated. 

Thanks

[Anonymous]

Ok, as soon as I posted this, I solved it by appending query string ?web=1 at the end of link ofa document and it should open in browser rather than getting downloaded.

[Your Tenant Site]/Shared%20Documents/myTest.xlsx?web=1

[Anonymous]

By exploring a little more Flow, I have noticed that there is 'Link to Item' in dynamic content area which was initially hidden away. So no need to do hacks anymore.