AI Builder / File Look-Up

[dhaberkorn]

Novice user here and I've hit a wall.
Use case: Automated invoice look-up based on a forms response, used by multiple sites across the country.

I've set up an AI Model that extracts the PO Number and the delivery zip code from the invoice, and then renames the file to the cadence of "PONumber-ZipCode.pdf" in a pre-determined SharePoint folder.

I'm now trying to establish the flow that, based on the user's entry of PO Number and Zip Code, PowerAutomate would search the folder for said invoices and return a link to a URL to the document results via email. My stall point is that some zip codes are coming in as 5-digit where some have full postal zip of 5digit-4digit, and some PO#s are including the Hashtag or some additional letters. Therefore, I can't just have it search for the file name in such a set string. I'm trying to get the system to return up to 5 files (margin for error, especially during pilot).

My flow is below, but I don't know how to set up the query to search for file names that include the variations, not just a pre-set static file name cadence. Can anyone assist? 

[JoeF-MSFT]

Hi @dhaberkorn - welcome to Power Automate and AI Builder!

There are two operators you can use in the filter that can help you with this: startswith and substringof. Here are some examples on how to use them in your flow:

You can find more information about these operators here: https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/use-odata-query-operations-in-sharepoint-...

Hope this helps! 🙂