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
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,948)