cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Initializing Object Variable - Mapping

Hello,

 

I'm trying to build a flow where whenever a new email comes in that has an attachment (.xlsx, .csv, .txt, etc.) and has a variable = "XYZ" to save the attachment(s) to a specific file folder, "XYZ_COMPANY". So far, the flow works for the first array (I hope I'm using the correct terminology) under "XYZ", but will not work for the second, "ABC". When an email with variable = "ABC" comes in with attachments, the flow will save the attachments to file folder "XYZ_COMPANY", when it should save the attachments to "ABC_COMPANY".

 

    Flow_1.PNG

 

 

{  


"foldermapping": [    


{      


      "FolderNameField": "XYZ_COMPANY",


      "sender": "XYZ"


    },    


{      


      "FolderNameField": "ABC_COMPANY",


      "sender": "ABC"


    } 


 ]


} 

 

 
Flow_2.PNG

 

variables('FolderName')['foldermapping'][0]['FolderNameField']

 

first(split(last(split(triggerBody()?['From'],'@')),'.com'))

 

 

 Flow_3.PNG

 

 

variables('FolderName')['foldermapping']

 

 

item()['sender']

 

 

 Flow_4.PNG

 

Flow_5.PNG

Folder path:

\\folder_path\ABC_COMPANY\

The Output under Folder path is generated from 'ComposeFolderName'

 

The Output under File name is generated from 'Compose-ConcatFullFileName'

 

This is my first post, so I hope I provided enough detail and explained the flow ok.

 

Many Thanks,

 

NT22

1 REPLY 1
v-yuazh-msft
Community Support
Community Support

Hi @Anonymous,

 

Thank you for your sharing, I believe many peope would benifit from it.

 

Best regards,

Alice

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (5,017)