This functionality can help users deal with multiple values in a query range. You can:
This tool was initially migrated to D365FO by Anton Kazarnovsky. Then it was slightly polished.
To use this feature, you need to go to Options-Page options and press Advanced filter or sort button(or use Ctrl + Shift + F3 shortcut).
A new button List of values was added on this form. If you press this button a new form will appear with two parts:
In the upper part (Column view) you can find a user-friendly view of the values in the selected range. Here you can:
In the bottom part (Range friendly view) you can find the resulting query range. Here you can:
After you have finished editing of the values list, you can review the final range value in the bottom part, and press 'OK'. Then the query range will be updated with the values. Several new ranges for the same field will be created if the length of the value list doesn't fit in one range.
The standard system allows you to paste the value list from Excel, but the resulting range is limited to 4K chars(range size). So if you filter more(on average it is 300-400 invoices for example), you range will be truncated. Paste lists from Excel into filter fields with the "is one of" operator
The approach used in this tool also has a limit - 2100 parameters. This is a technical limitation (https://cloudblogs.microsoft.com/dynamics365/no-audience/2010/05/10/binding-operation-failed-to-allocate-buffer-space/) (thanks @IevgenMir for pointing on that)
List of Values to Range tool can simplify your work with multiple query ranges. You can download it using the following link - https://github.com/TrudAX/XppTools#installation
Feel free to post any comments(better as a GitHub issue) or ideas, what else can be improved.