Hi all, first post here so hope it's detailed enough!
I'm trying to use PA to extract detail from a Planner to use in PowerBI, however I am having issues with the 'Label' for each Task.
Couple of bits of info:
- Labels are availalble via the "List Tasks" action, but they show as "category1", "category2" etc, rather than their names as shown in Planner.
- The actual label names are available via the "Get Plan Details" action.
I am aiming to use this to create a mapping table so I can represent the correct names in my PowerBI app.
The issue I have is, I pass the "CategoryDescriptions" from the output of Get Plan Details into a Select, but I then get the error:
"The 'from' property value in the 'select' action inputs is of type 'Object'. The value must be an array."
The inputs to the Select are:
{
"from": {
"category1": "oneITSM",
"category3": "Process Advisory ",
"category13": "To be confirmed",
"category21": "Parked"
}
}
No idea where to go with this, so any help/pointers would be much appreciated!
Thanks
