Media Image Reference

[NumericDreamz]

I have several images stored in Media.  In a gallery I have an image control with the Image value set to... 

ThisItem.ImageFileName

This obviously doesn't work.  The file name for each image is stored in a collection of records.  I just need this image to change as the individual records are pulled up.  Anybody have a suggestion?

[Meneghino]

Instead of storing the file name, store the image itself in the collection.

You can specify the image in a ClearCollect or Collect statement.

[NumericDreamz]

Okay, I tried that by putting the images into the spreadsheet table the data is pulled from and it didn't work either.  How exactly do I accomplish this?

[Meneghino]

Then you can do it with IDs and a virtual table.

Please Skype me on baizini, it will be quicker.

[NumericDreamz]

Sorry, but our factory is too loud to Skype.  Workstation is not equipped for teleconference anyway.

[Meneghino]

OK, set IDs in your table, then set the image control property to

LookUp(
    Table(
        {ImageId:1, MyImage:NameOfImage1},
        {ImageId:1, MyImage:NameOfImage2},
        etc. etc.
        ),
    ImageId=ThisItem.Id,
    MyImage)

[NumericDreamz]

Okay, this is a method I have not yet tried.  Before we go down this path let me show you where I'm currently at and perhaps you can tell me what my issue is.  I've switched over to the method in this post.  Instead of embedding the images into the spreadsheet table I've uploaded them to a OneDrive for Business folder that is shared to my team and I have the path in the table instead.

./Personnel/EmployeeImage.jpg

However, this is what I get in my collection...

Looks like the links are broken but the path appears correct and the directory is shared to the users.  Any ideas?  

[NumericDreamz · Accepted solution]

NVM  I figured it out.  You have to go into OneDrive and copy the full link for each image you've shared and put that into the spreadsheet table instead of the shorthand link.