Unanswered

Error creating variable path on Shared Documents

(0) Share

Report

Posted on by Sormick

566

there is a tutorial here: https://www.youtube.com/watch?v=u-b8w9ea1kk to access files and folders on a document library.

i have an error on this Variable:

set(varfolderpath,"Shared Documents")

also tried with set(varfolderpath;Text( "Shared Documents")

but still get an error on my variable.

also it seems that "on start" field of the app does not exist anymore.

Should i put my variable on the "formulas field of my app?

any suggestions?

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

mmbr1606 14,605 Super User 2025 Season 2 on at

Like (0)

Report

hey @Sormick

i guess u missed the / at the end so it should be set(varfolderpath,"Shared Documents/")

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No
mmbr1606 14,605 Super User 2025 Season 2 on at

Like (0)

Report

do you want to recreate the document library in powerapps?

Power Apps for SharePoint Document Library (youtube.com)

this is the best video i have found so far without delegation issue

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No
Sormick 566 on at

Like (0)

Report

Sorry, did not managed to add the column path on sharepoint.
Any tutorial to add this column?

Was this reply helpful? Yes No
mmbr1606 14,605 Super User 2025 Season 2 on at

Like (0)

Report

if you follow the link i provided it will be explained throuout the video.

a colleague of mine recently recreated the solution from the video and it worked perfectly

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No
Sormick 566 on at

Like (0)

Report

I'm sorry. still did not find the path field from the add column menu

Was this reply helpful? Yes No
mmbr1606 14,605 Super User 2025 Season 2 on at

Like (0)

Report

for the solution itself you do not need to add this column.

its enough when u add it to your sharepoint list. if its not in your list you wont find it here in powerapps

Was this reply helpful? Yes No
Verified answer

Sormick 566 on at

Like (0)

Report
unfortunately my files are not stored on a sharepoint list but instead on a document library.
What i've done to make my files delegable:
i've put all my files on multiple sub folders.all my files stored on sub folders contains less then 2000 files
i added a new "Text" column on my sharepoint document library named "Path".
I created a power automate flow with:
"When a new file is created". and the trigger condition: "@not(equals(triggerBody()?['{Path}'],triggerBody()?['Path']))"
Update file (properties) and on the "path" field i selected the folder path to populate automatically this field
Now for each of the the created file i have the folder path on the sharepoint column and all my files are now delegable!

Was this reply helpful? Yes No