I have a Gallery (Gal_Images) that is happily showing thumbnails of images that are in a folder location, these images are named under the convention "mtg-xxxxxx-yyyymmdd-description.jpg"
Where
'mtg; denotes a meeting ID , 'yyyymmdd' is the date and 'description' is a free field
Examples
mtg-000001-20230230-bird.jpg
mtg-000001-20230230-dog.jpg
mtg-000001-20230230-cat.jpg
mtg-000002-20230305-snake.jpg
mtg-000002-20230305-fish.jpg
My folder structure is in Sharepoint, so the gallery Gal_Images Items is set to :
Filter('MyDocumentLibrary','Folder path'="Top Level Folder/Project Folder/Image Files/")
This works fine
What I am trying to do is to limit the Gallery Gal_Images to ONLY show the files where the first 10 characters match that of a meeting ID that is selected from another Gallery (Gal_Meeting)
If I set a label to show "GalMeeting.Selected.MeetingID" I see the meeting ID I am trying to match against
I have been trying various combinations of 'and' statements and using the 'Left' function, but cannot get it quite right!
Very grateful for any steer anyone can give me,
James
