10/31/2023 0 Comments How to paste list into excel cellsThere are lots of pasting options – here is a quick example of how the Transpose option works. One way to achieve this would be by cutting and pasting individual cells. Sometimes when setting up a worksheet you may realise that it would be better to put your column data into a row. If you've enabled the Optimized "is one of" filtering experience that is also available in Platform Update 22, the visualization is even nicer, as shown in the following image.Easily copy & paste using the Transpose option The list from Excel will get expanded in the filter field as shown: If you want to filter Finance and Operations based on this list, simply copy the list from Excel, find the Voucher field filter in the Filter Pane on the Voucher transactions page, ensure the filter operator is set to is one of, and then paste the clipboard contents into the filter field. So for example, consider this list of voucher numbers in Excel: This includes a collection of values copied from different rows and columns in Excel. Starting in Platform Update 22, the "is one of" operator in the Filter Pane and grid column filtering now recognizes lists copied from Excel so that they can be pasted directly into a filter field. As an example, a finance user might have identified a set of vouchers from a report that need additional research in the system, and it would be ideal for this user to be able to copy the list directly from Excel into a filter field in Finance and Operations. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.įor some tasks, users might have a list of values in Excel that they'd like to use to filter data in Finance and Operations. For the latest documentation, see Microsoft Dynamics 365 product documentation. This content is archived and is not being updated.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |