Forum Discussion
Trying to find solution
Hi 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.
Backend SharePoint list with item for each Workplan component
PowerApps app embedded in SharePoint page - users could only change the % for the sub-component
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
Hi 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.
Backend SharePoint list with item for each Workplan component
PowerApps app embedded in SharePoint page - users could only change the % for the sub-component
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
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
Hi Clayton (ClaytonP ) sorry for the delay with posting up the steps, I'll try to do so tomorrow morning (Friday).
Rob
Los Gallardos- Rob
Any chance you can export or send me a ZIP file of how to do this.
Just found we have power apps and I am ready to go
ThanksRob
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