Hi,
I am trying to create a flow that runs once every week to generate a list of filenames with its metadata tag and sends one email. This is help review and validate all files have the right metadata value applied by other flows. I had no issues creating such a flow for metadata columns with single value in it. The bit where I am stuck at is where metadata column allow multi choice column. After reading its JSON file I realised that these multi choice metadata are nested within a JSON array with multiple objects.
I was not able to find any info anywhere a way to extract the value against the property "Label", is this even possible?
Here is an example of the JSON file.
[
{
"ID": 43296,
"Meta": [
{
"Label": "Label1",
"Path": null,
"Value": "Label1.Value"
}
],
"{Name}": "File1",
"{FilenameWithExtension}": "File1.pdf"
},
{
"ID": 43316,
"Meta": [
{
"Label": "Label2",
"Path": null,
"Value": "Label2.Value"
}
],
"{Name}": "File2",
"{FilenameWithExtension}": "File2.pdf"
},
{
"ID": 43377,
"Meta": [
{
"Label": "Label3",
"Path": null,
"Value": "Label3.Value"
},
{
"Label": "Label4",
"Path": null,
"Value": "Label4.Value"
}
],
"{Name}": "File3",
"{FilenameWithExtension}": "File3.pdf"
},
{
"ID": 43379,
"Meta": [
{
"Label": "Label1",
"Path": null,
"Value": "Label1.Value"
},
{
"Label": "Label4",
"Path": null,
"Value": "Label4.Value"
},
{
"Label": "Label7",
"Path": null,
"Value": "Label7.Value"
}
],
"{Name}": "File4",
"{FilenameWithExtension}": "File4.pdf"
}
]
From the above code how do I create the follwoing HTML table?
| Filename | Meta Label |
| File1.pdf | Label1 |
| File2.pdf | Label2 |
| File3.pdf | Label3, Label4 |
| File4.pdf | Label1, Label4 |
Please note, the Meta Label column could have upto 13tags within it. So having a dynamic expression to help complete the HTML table would be helpful.
Thanks in advance.
