Dynamically get the Sharepoint site URL of a Sharepoint Power App form

(0) Share

Report

Posted on by OmegaPhi115

I got a Power App form attached to a Sharepoint list I'm using as a developpement model.

Then, I'm using FlowPowerAppsMigrator to transfer the form to other Sharepoint sites made for clients.

I need to get the URL of the sharepoint site the form is currently on for some processing, however I can't seem to find a way to dynamically get it. I found this tutorial that is working, but require at least one item in the list, which isn't guaranteed.

Another way to do it would be to manually go change a static variable after migrating the model to the new site, which isn't ideal when there is already 10 sites and growing.

Any tips on it? This is quite an edge case, but I'd be glad to not have to do manual tweaking. I'm also willing to do Power Automate flows if needed.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@OmegaPhi115 - isn't this scenario exactly what Environment Variables are for?

https://learn.microsoft.com/en-us/power-apps/maker/data-platform/environmentvariables

Was this reply helpful? Yes No
OmegaPhi115 31 on at

Like (0)

Report
Copy link

Link copied!

That would be a great solution, except I cannot add the form to a solution.
To be clear, it's a sharepoint list form. One that shows up to edit the list directly. Not a Canvas App that drives a sharepoint list. Which means it's hidden from true powerapps

Unless there is a special way to force it into a solution, that doesn't work sadly

Was this reply helpful? Yes No
Verified answer

OmegaPhi115 31 on at

Like (0)

Report
Copy link

Link copied!
I managed to fix this using a dirty yet effective trick. Essentially, on startup, I get the first item, get the url, then save it into a variable.
If there is no items, I create a temporary new one, get its url, then remove it.
If( !IsBlankOrError(First('List Exemple')), Set( sharepoint_link, First( Split( First('List Exemple').'Link to item', "/_layouts" ) ).Value ), Patch( 'Suivi tickets MODEL', { title: "Systeme", } ); Set( sharepoint_link, First( Split( First('List Exemple').'Link to item', "/_layouts" ) ).Value ); Remove('List Exemple', First('List Exemple')) );

Was this reply helpful? Yes No