Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Need Ideas for SharePoint data and automating with Flow

(0) ShareShare
ReportReport
Posted on by 4

Hi,

 

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.

 

Categories:
  • beilermse Profile Picture
    beilermse 4 on at
    Re: Need Ideas for SharePoint data and automating with Flow

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

    http://i68.tinypic.com/220qo9.png

  • ScottShearer Profile Picture
    ScottShearer 25,150 on at
    Re: Need Ideas for SharePoint data and automating with Flow

    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?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,343

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard