cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mango2407
Frequent Visitor

How to get file or folder link within Sharepoint List

Dear all

 

I have done with my flow and working fine, Iam just having one addition to that is I want to get the File or Folder link from the sharepoint

 

How I can access that SharePoint link with SharePoint list??

 

Also how to map into Power automate

 

Please advise

1 ACCEPTED SOLUTION

Accepted Solutions
renatoromao
Super User
Super User

Hi @mango2407 ,

 

I recommend using REST API to get files inside the SharePoint list, using Power Automate.

https://docs.microsoft.com/en-us/sharepoint/dev/business-apps/power-automate/guidance/working-with-s...

 

In the HTTP request, you can follow this template to get files

/_api/Web/Lists/getByTitle('<list title>')/items?$select=File/ServerRelativeUrl&$expand=File

You can see this post on the forum: https://sharepoint.stackexchange.com/questions/118479/is-there-a-way-to-get-all-file-urls-for-a-libr...

 

And inside your Power Automate, you can use Markdown to show items inside the PVA chatbot, returning the markdown formatted response to the chatbot.

https://docs.microsoft.com/en-us/power-automate/approvals-markdown-support 


Did I answer your question? Mark my post as a solution!
Thanks!

Renato Romão,

Connect with me here 😉

Power Virtual Agents course (+2.650 students) : English | Português

View solution in original post

1 REPLY 1
renatoromao
Super User
Super User

Hi @mango2407 ,

 

I recommend using REST API to get files inside the SharePoint list, using Power Automate.

https://docs.microsoft.com/en-us/sharepoint/dev/business-apps/power-automate/guidance/working-with-s...

 

In the HTTP request, you can follow this template to get files

/_api/Web/Lists/getByTitle('<list title>')/items?$select=File/ServerRelativeUrl&$expand=File

You can see this post on the forum: https://sharepoint.stackexchange.com/questions/118479/is-there-a-way-to-get-all-file-urls-for-a-libr...

 

And inside your Power Automate, you can use Markdown to show items inside the PVA chatbot, returning the markdown formatted response to the chatbot.

https://docs.microsoft.com/en-us/power-automate/approvals-markdown-support 


Did I answer your question? Mark my post as a solution!
Thanks!

Renato Romão,

Connect with me here 😉

Power Virtual Agents course (+2.650 students) : English | Português

View solution in original post

Helpful resources

Announcements
PVA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Center-of-Excellence-Starter-Kit-cropped 768x460.png

The Total Economic Impact™ of Power Virtual Agents

Read this 2021 commissioned study, conducted by Forrester Consulting.

Top Solution Authors
Users online (1,159)