I have been working on getting data from Planner into Excel in hopes of eventually building Power BI reports. Although the data is limited in what I can get from Planner, I have been making progress. I have run into two issues:
1) I need to get the time format from this (2018-03-01T10:00:00Z) to this (3/1/2018). I have this working but not consistently using Convert Time Zone. Is there a better way to do this?
2) Fianlly, all the useful data outside of the Title field comes up as a hash. How can I convert this to real text? CvWkwzuhQU6s9EGYJGFHRWQAFrGl is not useful.