You’re offline. This is a read only version of the page.
I need Planner history data to be saved and to make it possible to see main information. Would like to use planner as a CMMS (factory maintenance system), but need clear and readable history, recurring tasks and few other things, that probably can be solved with Power Automate.
This is my history content imported from planner
a) I need Value Name instead of ID for Bucket and Assign to and other columns. I can not choose them from the list. Is there a way to add them?
Would like to have columns (Bold are already available to select): 1) Plan name; 2) Bucket name; 3) value Created Date Time; 4) value Created By User Display Name; 5) value Title; 6)value assignments Assigned To User Name; 7) value Completed Date Time 8 ) maybe something else...
b) Change the date to a more user friendly format. Need only date, no time perfect would be 17.03.2020
Hi @Anonymous ,
Please only fill the Dynamic content output from a trigger in Add a row into table action.
Image reference:
Best Regards,
hi @Anonymous you have an error in compose you have "Ass"
Hi @Anonymous ,
Please share the screenshot of the Flow configuration so that we could do some analysis.
Best Regards,
@v-bacao-msft Thank You! It worked, but for some reason it inserted the name 26 times instead of 1 🙂
And it makes 2 rows for 1 task in excel and shows like there were same tasks in both buckets.
Need to think how to continue. It is difficult to do or fix something if you don´t understand yourself how things work and what does what...
Hi @Anonymous ,
Please try to refer to the following method to get Bucket Name and Assigned To.
Hope this helps.
Best Regards,
Could it work the other way?
Create a new row in excel manually and Power Automate will create a new task in Planner? And after completing task, Power Automate will make changes to this row? This way I could use additional columns and data in Excel, that is not used by Planner.
It has been a journey for me to get the current flow working. I ask before start messing again.
I feel that it is weird that some values are available to import and some not.
What about using SharePoint List instead of excel? I can get same data to a List.
@Anonymous There are no way to get the Value Name in PA my friend. Just Using HTTP.
Thank You! This could do the trick.
I had the "create row to excel" in place. Created "get task" and "list buckets", "Compose Value Name".
I guess the order is important. So I have to first Compose all "Value Names" and then write to excel?
Export plan to Excel can get the details of all tasks of Plan since its creation, but it does not include the tasks that have been deleted.
Also if you want to get Assigned to user name and bucket name, please refer to these similar threads:
https://powerusers.microsoft.com/t5/Building-Flows/Getting-bucket-Name/td-p/171129
Best Regards,
#1
WarrenBelz
146,645
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,997
Most Valuable Professional
Share
Report
All responses (
Answers (
