I have a folder of thousands of images in my OneDrive. All images correspond with certain products. Each Product has multiple images. The filenames are constructed of the product name followed by a Sequence number. For example, product A has corresponding images with the file names:
ProductA_1.jpg
ProductA_2.jpg
ProductA_3.jpg
Is there a way that I can have an expression That looks up all images that start with a certain value? Something that would look like
CONCATENATE("/Images/",[Product name], โAny Other Valueโ)
Doubt this is possible but would love to find a solution that doesnโt require me to create a sheet for the images that the product sheet can reference, but rather just references the images from the folder directly.
User | Count |
---|---|
42 | |
32 | |
24 | |
23 | |
14 |