Answered

Error creating variable path on Shared Documents

(0) Share

Report

Posted on by Sormick

361

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:

Using Apps Using Formulas

All responses (7)

Answers (1)

Verified answer

Sormick 361 on at

Like (0)

Report
Re: Error creating variable path on Shared Documents

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!
mmbr1606 9,998 on at

Like (0)

Report

Re: Error creating variable path on Shared Documents

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
Sormick 361 on at

Like (0)

Report

Re: Error creating variable path on Shared Documents

I'm sorry. still did not find the path field from the add column menu
mmbr1606 9,998 on at

Like (0)

Report

Re: Error creating variable path on Shared Documents

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
Sormick 361 on at

Like (0)

Report

Re: Error creating variable path on Shared Documents

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

Like (0)

Report

Re: Error creating variable path on Shared Documents

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
mmbr1606 9,998 on at

Like (0)

Report

Re: Error creating variable path on Shared Documents

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