Answered

SQL records being displayed in a Gallery but using SharePoint Document Library for Attachments

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

All,
I have built a Gallery(GalleryMain) using SQL DB pulling in information. I have created a AttachmentControl using Power Automate to take those attachments and dump them into a SharePoint Document Library(TestDoc). Inside the Power Automate, it takes the SQL DB ID and creates that ID as the folder name and then dump those files in the Attachment Control in that folder.

Folder name 2 -> test.doc ; test.txt and so on

In my main Gallery(GalleryMain), when you select row ID 2, I want to be able to see ONLY those files associated in TestDoc/2(folder name) for that current selection? I hope this makes sense. This is possible?

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

Yes, you simply need to filter your document library by the column that you are using to store the ID from the DB.

Ex. Filter(yourLibrary, SQLIDColumn=yourGallery.Selected.ID)

I hope this is helpful for you.
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

@RandyHayes Thank you that worked great. I appreciate you getting back to me ASAP on this. I appreciate it. Have a great day!
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

No problem! Have a great day also!