cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kind
Frequent Visitor

Sharepoint document library

Hi,

 

I am a beginner to power apps. My problem is that I have a SharePoint document library and I would like to share folders (a collection of documents) and keep track of comments with a timestamp and user. Since comments on a folder with these logging requirements are not supported on sharepoint, I was thinking of creating a powerapp which will allow me to share a folder and keep track of comments,timestamp and user in a custom column. Is this possible first of all and is it a good solution?  Also are there good tutorials online that can get me started to connect a powerapp with a document library and access column data and user data?

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-yutliu-msft
Community Support
Community Support

Hi @Kind ,

Do you want to create an app about updating comments on file in sharepoint library?

If so, here's my advice:

1)create a sharepoint library to upload files

2)create a sharepoint list to record comments for these files with these fields:

a multiple line of text column :record comments

a lookup field(lookup to the ID in  sharepoint library): choose related file

(No need to add person field and time field, there will be metadata fields: Created, Created By)

3)in your app

connect with this list and this library

(Please notice that you could only view column data of library in powerapps, you could not view file content in powerapps)

insert gallery1, set its Items: libraryname

insert gallery2, set its items:

Filter(listname,lookupfielname.Value=Gallery1.Selected.ID)

//then gallery2 will only display the comments for the selected file

insert "+" button, set its OnSelect:

Navigate(Screen2);NewForm(Form1)

set the arrow button's OnSelect inside gallery2:

Navigate(Screen2);EditForm(Form1)

//if you want to create new comments, click the "+" button, if you want to edit comments, click the arrow button in gallery2

4213.PNG

 

in screen2, insert an edit form

set the form's data source to your list name

set the form's Item to : Gallery2.Selected

insert a submit button, set its OnSelect:

SubmitForm(Form1);ResetForm(Form1);Back()

After you enter data in this form, click the submit button. You will submit the comments and back to the gallery screen.

4214.PNG

 The key point of your issue is to create a lookup field in your list and create an app connected with list and doc.

Then filter comments based on selected file. Then is the part about the integration of gallery, edit form.

These docs may help you:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/connections/connection-sharepoint-onlin...

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/working-with-forms

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-yutliu-msft
Community Support
Community Support

Hi @Kind ,

Do you want to create an app about updating comments on file in sharepoint library?

If so, here's my advice:

1)create a sharepoint library to upload files

2)create a sharepoint list to record comments for these files with these fields:

a multiple line of text column :record comments

a lookup field(lookup to the ID in  sharepoint library): choose related file

(No need to add person field and time field, there will be metadata fields: Created, Created By)

3)in your app

connect with this list and this library

(Please notice that you could only view column data of library in powerapps, you could not view file content in powerapps)

insert gallery1, set its Items: libraryname

insert gallery2, set its items:

Filter(listname,lookupfielname.Value=Gallery1.Selected.ID)

//then gallery2 will only display the comments for the selected file

insert "+" button, set its OnSelect:

Navigate(Screen2);NewForm(Form1)

set the arrow button's OnSelect inside gallery2:

Navigate(Screen2);EditForm(Form1)

//if you want to create new comments, click the "+" button, if you want to edit comments, click the arrow button in gallery2

4213.PNG

 

in screen2, insert an edit form

set the form's data source to your list name

set the form's Item to : Gallery2.Selected

insert a submit button, set its OnSelect:

SubmitForm(Form1);ResetForm(Form1);Back()

After you enter data in this form, click the submit button. You will submit the comments and back to the gallery screen.

4214.PNG

 The key point of your issue is to create a lookup field in your list and create an app connected with list and doc.

Then filter comments based on selected file. Then is the part about the integration of gallery, edit form.

These docs may help you:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/connections/connection-sharepoint-onlin...

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/working-with-forms

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,377)