News and Announcements icon

Power Platform CommunityForums Power Automate - Using Flows Use sharepoint links a...

Power Automate - Using Flows

Unanswered

Use sharepoint links as input to access excel

(0) Share

Report

Report

Posted on by poc1

Hi everyone,

I am having the following issue with the flows:

I have an excel file (EXCAL A) with a table in which in one of the columns contains SharePoint links to different excel files
- The link would be something like:
  - https://azurecompany.sharepoint.com/:x:/r/sites/Proyectos/Shared%20Documents/General/GESTION/01_xxxxx/STO%20RIESGOS%20PROYECTO%20-%20IDXXXXA.xlsx?d=wad9177db26aa47298f5de30f1c424454&csf=1&web=1&e=Xfwd0A
  - Lets call the excels of the link EXCEL B1, EXCEL B2,.... EXCEL Bn
I can access the table information with "List rows present in a table" to get the link string on EXCEL A
With the link string I would like to be able to access the link excel file to check and review information on the excel of the links (EXCEL Bn)

How could I achieve this?

Thanks!

Kind regards

All responses Img

All responses (1)

Answers Img

Answers (0)

narayan225 2,449 Super User 2025 Season 1 on at

Like (0)

Report
Re: Use sharepoint links as input to access excel

@poc1

In the string, you will have the file name and location. However, there is no table information in the URL. It is better if you save the file location from the root and the table names in two columns as strings instead of saving the url.

You can do the following as well:

Use the URL to download the file in your SharePoint.

Get the table in the downloaded file.

Do your actions.

Delete the downloaded file.

Hope this helps!

Cheers!

Helpful resources

News and Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸

Replay: Power Platform Community AMA - Copilot Studio | April

Welcome to the Power Platform Communities

Quick Links

Leaderboard

#1

WarrenBelz 146,651 Most Valuable Professional

#2

RandyHayes 76,287 Super User 2024 Season 1

#3

Pstork1 65,999 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow

Product updates

Microsoft Power Platform Community release plans