Share
Report
69Hello Folks,
I have created collection/JSON on Powerapps that has grouped data and want to send this data to word template as report:
the word report will have 2 sections:
1. Department #, Department Name, Department Address, Department Phone ( this section will be added as bullets)
2. Second section is a table of all products linked to this department #
the table will have Product#, Product Description, Unit Price, Purchase Date .....
the JSON I have is presented as follow:
[
{
"Department": "00001",
"Product_Data": [
{
"Product#": "xxxx",
"Product Description": "xxxxxx",
"Price": "xxxxxxx"
},
{
"Product#": "xxxx",
"Product Description": "xxxxxx",
"Price": "xxxxxxx"
}
]
},
{
"Department": "00002",
" Product_Data ": [
{
"Product#": "xxxx",
"Product Description": "xxxxxx",
"Price": "xxxxxxx"
},
{
"Product#": "xxxx",
"Product Description": "xxxxxx",
"Price": "xxxxxxx"
},
{
"Product#": "xxxx",
"Product Description": "xxxxxx",
"Price": "xxxxxxx"
}
]
},
{
"Department": "00003",
" Product_Data ": [
{
"Product#": "xxxx",
"Product Description": "xxxxxx",
"Price": "xxxxxxx"
},
{
"Product#": "xxxx",
"Product Description": "xxxxxx",
"Price": "xxxxxxx"
}
]
}, ..........
Please let me know if any questions.
Thank you in advance.
All responses (
Answers (
