Unanswered

How to Store connection URL in variable

(0) Share

Report

Posted on by Anu262022

Hello,

I am able to connect SharePoint Online site. Now I want to store connected SharePoint Site Url in variable, I want to pas this url into PowerAutomate Flow.

How can I store url in a variable?

Avi

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

JR-BejeweledOne 5,836 Moderator on at

Like (0)

Report

Is the URL static or will it change?

Was this reply helpful? Yes No
Anu262022 4 on at

Like (0)

Report

It is the same URL when we connected to the edit form with data connection with the existing SharePoint Site?

Was this reply helpful? Yes No
JR-BejeweledOne 5,836 Moderator on at

Like (0)

Report

Copy the link to the SharePoint site from the browser. In the OnVisible of the screen set a variable with the copied link.

Set(varSPLink, copied url). You may want to enclose it in "" like Set(varSPLink, "http://sharepointsite.com"). Now you can pass varSPLink to your flow. You will need to test it with and without the quotes around the URL to see which works.

Was this reply helpful? Yes No
Anu262022 4 on at

Like (0)

Report

I know these basic steps. We cant hard code the URL,

Currently, I am using a test URL for development purposes, when we deploy the form in production, then again we need to open power app form and update the url manually. I want to avoid this.

Was this reply helpful? Yes No
JR-BejeweledOne 5,836 Moderator on at

Like (0)

Report

Another option would be to create a list in your SharePoint site. Add a single item with the URL and then add this list to the App as a data source. You can then either set a variable with the URL on app start, or screen visible and use it in the flow that way.

This allows you to use your test site for now and when you go to production you just update the link in the list.

Was this reply helpful? Yes No