Product Information App (noob question)

[GlennG77]

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

[WarrenBelz]

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]

Hi @WarrenBelz, 

Thanks for the quick response. The solution in you blog using "First(ThisItem.Attachments).Value" for the attachment in the list worked, but I have no idea if you can bulk add 500+ attachments to the list in Sharepoint.

I'm such a noob, the framework for this app is the "create an app from Excel/Sharepoint list" and I had to create my very first Sharepoint list to do this (from an Excel file).  Everything in the default app works for me. I'm just stuck on displaying all these product images. Linking to the images in the library (Cat21Images), using the item code in the sharepoint list (PowerAppsData-Cat21) as the reference is making my head run in circles.

[WarrenBelz · Accepted solution]

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.

[GlennG77]

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

[WarrenBelz]

Hi @GlennG77 ,

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