You would like to let the user provide a list of IDs as an input trigger and the action "Get items" should then load only the items in that list? Here is a quick solution for this problem. As a bonus, the flow will simply load all items, if no input was provided by the user.
The approach uses a custom filter query extension to load only these specified input IDs.
Customize the flow's trigger input. Important: Make the field is optional by clicking on the three dots next to the input and selecting "Make field optional". Here is an example.
Then initialize a string that will help us build the filter query extension.
Then add a condition that checks, if the user has provided some trigger input (e.g. "1, 2, 3") when running the flow. Use the expression triggerBody()?['text'] on the left. The question mark is crucial here! It assures the flow won't crash when there is no trigger input, but rather return null.
Inside the "true" branch, let's compile the query extension now. The inserted expression is:
This expression does three things at once:
a) remove all whitespaces
b) split the string (using the coma as delimiter) into a temporary array
c) join the array, using the phrase ' or ID eq ' in-between the ID values
The result may look something likes this (for the given trigger input: "1, 2, 3"):
and (EquipmentID eq 1 or EquipmentID eq 2 or EquipmentID eq 3 )
All that's left to do, is to append this string variable to the filter query of your "Get items" as dynamic content. Here is an example:
Note: If the user didn't provide an trigger input parameters, then the variable will remain empty and the filter query remains unchanged, otherwise our concocted query extension will make sure only the IDs are loaded specified by the user.
"ID" is of course only an example, you can also use this approach to custom filter other Sharepoint list columns.
