Jan 02 2020 12:44 PM
I am trying to set a SharePoint list that has workplans for example:
1.1 Workplan A (only has 1 sub component 1.1.1)
1.2 Workplan B (but workplan B has 3 sub components 1.2.1 - 1.2.2 - 1.2.3)
1.3 Workplan C (but workplan C has 5 sub components 1.3.1 - 1.3.2 - 1.3.3 - 1.3.4 - 1.3.5)
My goal is, I can do a percent complete on each sub component (that is a manual entry by the user)
I want to be able to take the sub components and do an average of each workplan to see how much has been completed (%) in each of the Workplans.
for example:
workplan B - sub components 1.2.1 = 50%
1.2.2 = 20%
1.2.3 = 35%
Total workplan B % = 35% (sub 1 + sub 2 + sub 3 = 105 / 3 = 35%)
I tried Calculated columns but they will only work on the same row.
Anyone out there that can help it would be really appreciated.
I have columns setup for WorkPlan, Subcomponent, subcomponent %, and Workplan %
Jan 03 2020 06:50 AM - edited Jan 03 2020 07:10 AM
SolutionHi @ClaytonP you'd really need to do this by building a fairly simple PowerApps app which you could embed on your SharePoint page so users wouldn't go into the list itself. They would update their individual component percentages and you could see the overall percentage complete as well as the percentages for the different workplans.
If that's the sort of thing you want I'll post up the detailed steps.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
Jan 03 2020 07:05 AM
Rob, that looks almost exactly what I am looking for.
Thank you very much for getting back to me.
If you wouldn't mind posting the steps that would be great.
I am still fairly new at a lot of this but am being tasked with these type things all the time and couldn't find a good solution.
Again this looks great.
If the steps are to cumbersome for posting here let me know and I have no problem giving you my work email if that is allowed.
Again thank you
Clayton
Jan 09 2020 09:42 AM
Hi Clayton (@ClaytonP ) sorry for the delay with posting up the steps, I'll try to do so tomorrow morning (Friday).
Rob
Los Gallardos
Feb 03 2020 08:05 AM
Feb 10 2020 07:14 AM
Rob
Not sure if you got my last post or not.
But I found our org. now has power aps and would really like to know how you did the formulas etc to do the roll up on the percentages.
If you could either email me or post that would be great.
Thank again for all your help
Feb 10 2020 07:19 AM
@ClaytonP thanks for chasing me on this. I'll dig out the solution and post here shortly.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
Feb 11 2020 01:33 PM - edited Feb 11 2020 01:34 PM
Hi @ClaytonP, for the SharePoint list I just have 3 columns:
I've exported the app which is attached and hopefully you'll be able to import it successfully into Power Apps. You'll need to add the data source in the app as the list on your site.
When you edit the app you'll see the yellow triangle delegation warnings on the calculations. They won't cause a problem unless you have a massive list.
Let me know if you have any problems or questions.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
Jan 03 2020 06:50 AM - edited Jan 03 2020 07:10 AM
SolutionHi @ClaytonP you'd really need to do this by building a fairly simple PowerApps app which you could embed on your SharePoint page so users wouldn't go into the list itself. They would update their individual component percentages and you could see the overall percentage complete as well as the percentages for the different workplans.
If that's the sort of thing you want I'll post up the detailed steps.
Rob
Los Gallardos
Microsoft Power Automate Community Super User