Power Platform Community Forum Thread Details

Hi All,

Im working with JIRA API and getting successful response. But the response is nested and Im unable to get all the text from the nested content and concat it. Your help is appreciated. Below is the JSON im working with. Can you suggest an expression in COPILOT Studio that can be of help for this problem

{
"fields": {
"description": {
"content": [
{
"content": [
{
"text": "### Productivity Dashboard Design:",
"type": "text"
}
],
"type": "paragraph"
},
{
"content": [
{
"content": [
{
"content": [
{
"text": "Left Section: Displays Jira data, including metrics like story points completed and issues resolved.",
"type": "text"
}
],
"type": "paragraph"
}
],
"type": "listItem"
},
{
"content": [
{
"content": [
{
"text": "Right Section: Contains Clarity hours, detailing the actual hours worked after accounting for holidays, vacations, and sick leaves.",
"type": "text"
}
],
"type": "paragraph"
}
],
"type": "listItem"
}
],
"type": "bulletList"
},
{
"content": [
{
"text": " ",
"type": "text"
}
],
"type": "paragraph"
},
{
"content": [
{
"text": "### Core Features:",
"type": "text"
}
],
"type": "paragraph"
},
{
"attrs": {
"order": 1
},
"content": [
{
"content": [
{
"content": [
{
"text": "Productivity Tracking: Enables calculations for:",
"type": "text"
}
],
"type": "paragraph"
}
],
"type": "listItem"
}
],
"type": "orderedList"
},
{
"content": [
{
"content": [
{
"content": [
{
"text": "Weekly",
"type": "text"
}
],
"type": "paragraph"
}
],
"type": "listItem"
},
{
"content": [
{
"content": [
{
"text": "Monthly",
"type": "text"
}
],
"type": "paragraph"
}
],
"type": "listItem"
},
{
"content": [
{
"content": [
{
"text": "Quarterly",
"type": "text"
}
],
"type": "paragraph"
}
],
"type": "listItem"
}
],
"type": "bulletList"
},
{
"content": [
{
"text": " ",
"type": "text"
}
],
"type": "paragraph"
},
{
"attrs": {
"order": 2
},
"content": [
{
"content": [
{
"content": [
{
"text": "Actual Hours Formula:  ",
"type": "text"
}
],
"type": "paragraph"
}
],
"type": "listItem"
}
],
"type": "orderedList"
},
{
"content": [
{
"type": "hardBreak"
},
{
"text": "   {Actual Hours Per Month} = (160 *times Number of Team Members}) -{Holidays} - {Vacations} - {Sick Leaves}",
"type": "text"
}
],
"type": "paragraph"
},
{
"content": [
{
"text": " ",
"type": "text"
}
],
"type": "paragraph"
},
{
"attrs": {
"order": 3
},
"content": [
{
"content": [
{
"content": [
{
"text": "Productivity Formula:  ",
"type": "text"
}
],
"type": "paragraph"
}
],
"type": "listItem"
}
],
"type": "orderedList"
},
{
"content": [
{
"type": "hardBreak"
},
{
"text": "{Productivity} = {Story Points Completed in a Month} * 160}/{Actual Hours}",
"type": "text"
}
],
"type": "paragraph"
},
{
"content": [
{
"text": " ",
"type": "text"
}
],
"type": "paragraph"
},
{
"content": [
{
"text": "### Visualization and Implementation:",
"type": "text"
}
],
"type": "paragraph"
},
{
"content": [
{
"content": [
{
"content": [
{
"text": "Use visual tools like bar charts for productivity comparisons and line graphs for story point trends.",
"type": "text"
}
],
"type": "paragraph"
}
],
"type": "listItem"
},
{
"content": [
{
"content": [
{
"text": "Data integration with Jira and Clarity APIs ensures seamless updates.",
"type": "text"
}
],
"type": "paragraph"
}
],
"type": "listItem"
},
{
"content": [
{
"content": [
{
"text": "Consider employing platforms like Power BI or Excel for interactive dashboards.",
"type": "text"
}
],
"type": "paragraph"
}
],
"type": "listItem"
}
],
"type": "bulletList"
}
],
"type": "doc",
"version": 1
},
"summary": "Monthly Productivity Calculation"
},
}

Categories:

General topics