Query a spreadsheet and then display a directory of photos

%3CLINGO-SUB%20id%3D%22lingo-sub-2162505%22%20slang%3D%22en-US%22%3EQuery%20a%20spreadsheet%20and%20then%20display%20a%20directory%20of%20photos%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2162505%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3EI%20have%20a%20spreadsheet%20and%20I%20want%20to%20be%20able%20to%20query%20it%20and%20then%20show%20the%20file%20directory%20relevant%20to%20the%20result%20of%20the%20query%3C%2FP%3E%3CP%3Ee.g.%20search%20the%20spreadsheet%20for%20sunsets%20in%20Wales%20and%20the%20result%20would%20show%20a%20link%20to%20the%20Windows%20directory%20that%20contains%20photos%20of%20sunsets%20in%20Wales.%3C%2FP%3E%3CP%3EHas%20anyone%20done%20anything%20similar%20or%20have%20some%20ideas%20to%20achieve%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20office%20365%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2162505%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hi

I have a spreadsheet and I want to be able to query it and then show the file directory relevant to the result of the query

e.g. search the spreadsheet for sunsets in Wales and the result would show a link to the Windows directory that contains photos of sunsets in Wales.

Has anyone done anything similar or have some ideas to achieve this?

 

I have office 365

3 Replies

@Linreading Interesting question. You say "I want to be able to query it". Do you mean to filter data from a table where a comment field may contain your search key, or do you want to connect, with Power Query, to a file directory with pictures that have file names that may contain the search key?

@Riny_van_Eekelen 

Hi Thanks for your question.

I have a spreadsheet with thousands of rows of information (but only about 8 columns). I intend to put a frontsheet that will allow someone to pick a from a set of queries that will already be set up, just as an example:

 1.Query how many photos of sunsets are there in the dataset

( have aloready got this query)

and then either depending on which might be possible

Would you like to see the files that contain photos of sunsets in Wales

or would you like to see the images of photos of sunsets in Wales

 

Thanks

@Linreading Could you upload an example with say 50 rows of data (not thousands) and a set of "queries" that could work on those 50. Expect it to be difficult to open and viewing files. though. That would probably require VBA, which isn't my favourite subject.