cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gtownsen
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?

 

Thanks,


GT

1 REPLY 1
gtownsen
New Member

gtownsen_0-1640271710960.png

 

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

Announcements
October Events

Mark Your Calendars

So many events happening this month - don't miss out!

 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

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

Top Solution Authors
Users online (1,830)