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:
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.