I want to use SharePoint Online to store images (PDF) of invoices. There will ultimately be 100,000+ documents, stored in a 3 level folder structure by YYYY -> MM -> DD.
Associated with each document will be a number of metadata elements / attributes - such as Vendor Name, Invoice Number, Invoice Date, Invoice Amount.
I want to allow users to search on any of those specific metadata elements, and bring back only documents which have the specific value entered by the user. For example - InvoiceNumber - "INV123". Ideally the search results page will provide a grid-type listing, showing the full set of metadata in columns.
Is this possible with SharePoint Online, using out-of-the-box functionality?
I've played around trying a few things - filtering, managed metadata etc - and nothing seems really applicable to this type of usage.
In other situations, we have used SharePoint hosted in-house, and we found we had to develop a search page and use the SP search API to get what we wanted. That's not so easy with SP Online, and was hoping we could use something more configured as opposed to developed.
Any help / guidance / suggestions would be much appreciated.