Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Need Ideas for SharePoint data and automating with Flow



This is a fairly broad question which could perhaps cover SharePoint, Flow, and/or Powerapps. We are building an ERP system using our SharePoint online as a foundation. Currently we are using the below excel format for personnel utilization and I am looking for ideas on how to replicate this data in SharePoint (probably using lists?). Once a month, a manager will enter their estimates for each person for each project. Employees are also added and taken off this spreadsheet irregularly. Currently the manual process includes copying the columns from last month into blank fields. I would like to autmoate this using flow to automatically create a new set of columns each month for that month (if this is possible). And I would use flow to add or remove projects and employees using other forms that already exist. My biggest hurdles are how do I store this data, so that managers can enter it similar to how they would enter it using excel. I am open to creating a PowerApp or InfoPath form, but I don't want them to need to click through too many screens and the PowerApp or form would also have to change dynamically when new projects and employees are added and removed. Thanks for any help.


Super User III
Super User III

I sounds as though you had intended to provide an example of how the dtat is currently stored in Excel but I din't see it.  Can you post what the data looks like?


Also, havve you considered using Project Online or leveraging the integration features of the Project desktop application with SharePoint?

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.


The attached image appears to me.  I'll post a direct link.

Helpful resources

Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Users online (74,855)