We can filter multiple records by providing a comma separated value as filter.However this is not always easy to filter data when there are large set of values to filtered.
For example if user wants to filter say 50 voucher transactions ,it is not easy to filter the transactions by providing a comma separated value of 50 vouchers.So there should be a provision where user can copy the data from a tabular format say excel or even from AX grid to clipboard and paste the data to filter in a tabular format and filter the records
This would be easy for the end user to filter records based on multiple criteria in a tabular format instead of comma separated value
Comments
It is already implemented in standard - https://docs.microsoft.com/en-us/business-applications-release-notes/october18/dynamics365-finance-operations/paste-filter-lists-from-excel
If you want more advanced functionality (like more values that 1 range can contain) - you can check this open source tool - https://denistrunin.com/xpptools-listvaluestorange/
Category: Development
As a workaround to this I usually just add a comma in the next cell in excel and then copy paste to notepad then copy paste to filter 'matches'--but it would be nice if it just worked.
After about 20+ values though the matches filter scrolls off the screen(with no scroll bar) and there is not really a good way to remove 1 of the values near the bottom.
Category: Development