How do I get the URL and Hyperlink to each line in my Sharepoint List?

[bonjourposte]

I've uploaded a Sharepoint list of addresses to Power BI and created a point map out of it. 

Inspectors select the addresses they want and click this Power Automate button.

This Power Automate flow sends an e-mail to users when they've clicked the button. 

Those users then need to be able to open the e-mail, click on a hyperlink for that item number, which then takes them to that item in Sharepoint (it's a form they need to fill out).  How do I get the URL and hyperlink to the lines in my Sharepoint list?  If I could get them to autopopulate as soon as I upload the file to the Query Editor, that would be great.  

Thank-you.

[v-binbinyu-msft]

Hi @bonjourposte ,

I'm a little confused about your needs, Could you please explain them further?

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_ Binbin Yu

[bonjourposte]

Thanks for the reply.  So this is what our Sharepoint list looks like: 

As we know, that first column is hyperlinked.  How do we get the URL's for every line of that first column?  I want to create a custom column in Query Editor for them.

[v-binbinyu-msft · Accepted solution]

Hi @bonjourposte ,

Below is my test steps, please refer:

I crate a SharePoint Online List with link column, import it to Power BI Desktop then in Power Query Editor pane, you could expand the link column, and then you will get the link.

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.