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

Product Information App (noob question)

Totally noob question here, but I'm so noob I don't even know the terminology to search for.

 

I'm building an app for staff to quickly and easily find information about the 500+ items we sell. Initially it's just for information purposes, but as I learn, I want to build in abilities to create quotes, PO's, etc.

 

For now it's 500-600 products with details like code, sell price, buy price, supplier, description, etc. Down the line it could become 5000 products though, as I had entire supplier catalogues rather than just our most popular items.

 

My question is, what is the best, quickest, easiest way to set-up the source data to handle images? I can't figure out how to display images of the product on the Browse Gallery (see image). Do I have a Sharepoint Product Library? Is it a URL in the Sharepoint list with the other data? The images are always ProductCode.jpg.

 

Some tips on best data practices and then the FX on the browse gallery would be amazing. Obviously I want to avoid manually adding attachments or images to the existing list (But if that process can be automated, great). And thank you so much for such a silly early stumbling block.

 

Glenn

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @GlennG77 ,

For attachments, you cannot "bulk attach" 500 items - you would need to do each picture individually on the relevant list record (but this is a once-off task) - the code you mentioned would then work on each item.

For the Library, you would need to give each picture a different name, however one time-saver you could do is name them the ID number of the "parent" list (1.jpg, 2.jpg etc) and then in a SharePoint Datasheet view bulk copy and paste this into a numeric field to reference the picture. The picture is then

LookUp(
   YourLibraryName,
   YourRefField = ThisItem.ID
).'{Thumbnail}'.Large

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

View solution in original post

5 REPLIES 5
WarrenBelz
Super User III
Super User III

Hi @GlennG77 ,

I have a blog on SharePoint Image storing and viewing that may be of assistance. In your case, you could use a Library (although you would need to have different names on the files) and have an identifier (the ID of the parent item is a good one) in a field in the Library metadata. You could also consider simply attaching the image to each item - there is also the process for displaying these in the blog.

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

GlennG77
Frequent Visitor

Hi

 

Hi @GlennG77 ,

For attachments, you cannot "bulk attach" 500 items - you would need to do each picture individually on the relevant list record (but this is a once-off task) - the code you mentioned would then work on each item.

For the Library, you would need to give each picture a different name, however one time-saver you could do is name them the ID number of the "parent" list (1.jpg, 2.jpg etc) and then in a SharePoint Datasheet view bulk copy and paste this into a numeric field to reference the picture. The picture is then

LookUp(
   YourLibraryName,
   YourRefField = ThisItem.ID
).'{Thumbnail}'.Large

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

View solution in original post

Hi Warren,

Thank you, that worked. Looks l need to setup a Flow to add the RefField ID's to the Library from an excel sheet, as the 500 could possibly be done manually, but 5000 definitely can't be.

 

Appreciate your help.


Glenn

Hi @GlennG77 ,

You can bulk-paste them from Excel but need to do 50-100 at a time.

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

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

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

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.

Top Solution Authors
Top Kudoed Authors
Users online (3,068)