Obuka
Modul
Use Power Query to load data in Dataverse - Training
Learn how to synchronize data from different sources to a Microsoft Dataverse table using Power Query and create dataflows in Power Apps.
Reverse rows
With Power Query, it's possible to reverse the order of rows in a table.
Imagine a table with two columns, ID and Country, as shown in the following image.
Initial table with ID and Country columns. The ID rows contain, from top to bottom, values of 1 through 7. The Country rows contain, from top to bottom, USA, Canada, Mexico, China, Spain, Panama, and Columbia.
On the Transform tab, select Reverse rows.
The result of this operation will look as follows.
Output table with the rows reversed. The ID rows now contain, from top to bottom, values of 7 down to 1. The Country rows contain, from top to bottom, Columbia, Panama, Spain, China, Mexico, Canada, and USA.