Select values from nested array

(0) Share

Report

Posted on by nwkhattak

I am creating HTML table from array to post in teams.

This is what my array contains.

[
{
"id": "333333333333333sssssssssssssss,
"receivedDateTime": "2024-01-23T15:25:11+00:00",
"hasAttachments": true,
"subject": "Subject Email 1",
"attachments": [
{
"@odata.type": "#microsoft.graph.fileAttachment",
"lastModifiedDateTime": "2024-01-23T15:25:11+00:00",
"name": "Attachment File Name 1",
"size": 12739
},
{
"@odata.type": "#microsoft.graph.fileAttachment",
"lastModifiedDateTime": "2024-01-23T15:25:11+00:00",
"name": "Attachment File Name 2",
"size": 12739
}
]
},
{
"id": "333333333333333sssssssssssssss",
"receivedDateTime": "2024-01-23T15:24:50+00:00",
"hasAttachments": true,
"subject": "Subject Email 2",
"attachments": [
{
"@odata.type": "#microsoft.graph.fileAttachment",,
"lastModifiedDateTime": "2024-01-23T15:24:50+00:00",
"name": "Attachment File Name 1",
"size": 12739
},
{
"@odata.type": "#microsoft.graph.fileAttachment",,
"lastModifiedDateTime": "2024-01-23T15:24:50+00:00",
"name": "Attachment File Name 2",
"size": 12739
}
]

I am feeding this array into "From" field of my create HTML Table. then using Header and values fields it works for below ones.

EmailReceiveTime = Item()?['receivedDateTime']

EmailSubject = Item()?['subject']

But I also want to include Attachment file names regardless of how many attachments are there with each email (in this example its 2 emails and each email have two attachments)

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (1)

v-yueyun-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi , @nwkhattak
Thanks for your sample json for test first ! And according to your description, you want to show the attachments file names in your HTML Table.
This is my test flow and the result in the email:

(1)The Compose action is used to create the test data :
(2)The "Initialize variable " action:
(3)The "Apply to each" action:
items('Apply_to_each')?['attachments']
item()?['name']
json(concat('[',items('Apply_to_each'),']'))
Item()?['subject']
Item()?['receivedDateTime']
body('Select')?[0]

(4)The last two actions:
replace(replace(replace(body('Create_HTML_table_2'),'<','<') ,''',string('''')) ,'>' , '>')

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
Verified answer

Manish Solanki 15,167 Moderator on at

Like (2)

Report
Copy link

Link copied!
Hi @nwkhattak

Another efficient way is to use expression to combine the values of attachment names. Here is an example.

In this example, I have stored the input array in the compose action:

[
{
"id": "333333333333333sssssssssssssss",
"receivedDateTime": "2024-01-23T15:25:11+00:00",
"hasAttachments": true,
"subject": "Subject Email 1",
"attachments": [
{
"odata.type": "#microsoft.graph.fileAttachment",
"lastModifiedDateTime": "2024-01-23T15:25:11+00:00",
"name": "Attachment File Name 1",
"size": 12739
},
{
"odata.type": "#microsoft.graph.fileAttachment",
"lastModifiedDateTime": "2024-01-23T15:25:11+00:00",
"name": "Attachment File Name 2",
"size": 12739
}
]
},
{
"id": "333333333333333sssssssssssssss",
"receivedDateTime": "2024-01-23T15:24:50+00:00",
"hasAttachments": true,
"subject": "Subject Email 2",
"attachments": [
{
"odata.type": "#microsoft.graph.fileAttachment",
"lastModifiedDateTime": "2024-01-23T15:24:50+00:00",
"name": "Attachment File Name 1",
"size": 12739
},
{
"odata.type": "#microsoft.graph.fileAttachment",
"lastModifiedDateTime": "2024-01-23T15:24:50+00:00",
"name": "Attachment File Name 2",
"size": 12739
}
]
}
]

Next, use expression to combine the attachments names for a list item in "Create HTML table" action:

join(xpath(xml(json(concat('{"root":{"item":',item()?['attachments'],'}}'))),'//name//text()'),', ')

Pls use the same expression in your flow to get the desired result.

Output:

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
nwkhattak 25 on at

Like (0)

Report
Copy link

Link copied!

Thanks @v-yueyun-msft , @ManishSolanki Both.
Manish's Solution saves me from Loop and adding extra steps. Wish i was able to figure out these long powerful expressions.

Was this reply helpful? Yes No
v-yueyun-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi, @nwkhattak @ManishSolanki
Thanks for your response! Wow! It is amazing for the method @ManishSolanki post . I have learned a lot from it !!😆
Thanks both again!!!!

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No