Showing results for 
Search instead for 
Did you mean: 
New Member

How to evaluate cells in datatable and move

Good morning, 


I am trying to move a set of records from the past 20 years into a list of "events." Currently, we have the items we performed actions on listed down the first column, and when we performed an action (every 6 years), we put information under the corresponding year (listed down the row). This results in a lot of white space in the table and I would like to make it into a tabular table showing the records so I can more easily manipulate it. Is there any way to do this using Flows or Power Automate for desktop?




New Member



For reference, this is what the data currently looks like. I want to make it into a list of events that have the year, name of device, area, etc. The end goal is to make a database/dashboard to display all of the devices, when we performed a PM on them in the past, and be able to upload reports to their "file." Any recommendations on how I might accomplish this would be greatly appreciated.

Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Top Solution Authors
Top Kudoed Authors
Users online (5,620)