Hi,
I am developing a flow that can return results related to QMS documents' queries requested by users in Copilot Studio. The result is document links and their title in Copilot Studio.
1. In my flow, I am using AI prompt to extract useful information out of users' question. I have four variables / parameters such as document ID, ByTopic, Title and Product Category that are extracted from users' questions using AI prompt.
2. I am using Get Files (properties only) to fetch matching records. The filter query only gives you two options "and" "or" and if you select "and" then you must have all the variables' / parameters' values otherwise the results will be null.
Could you suggest any condition for filter query that can also provide results if some variables / parameters are empty with no values which means query will show results based on whatever information it has in hand e.g. if two parameters have values and remaining two are empty with no values.
Your help is much appreciated!
Overall flow
Get Files (Properties Only)