cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
yanni99
Helper II
Helper II

Creating an array for all attachements to save as Multiline text in Sharepoint

I am kind of lost here. First time using arrays in flow.

So what I want is I want to be able to save all File Path of all email attachements as a hyperlink in a Multiline text in Sharepoint to be used in Powerapps.

This is what I have so far, I think I am on the right track, but I don't know what I should put in my Json.

 
 
 

As you can see I can't figure out the JSON (if needed) or the Append to array.

 

Edit: And i can't seem to be able to add pictures for some reasons

I wil try to describe what I have so far

Initialize Variable - FilePath - Array

Apply to each - Attachments

Sharepoint - Create File

Sharepoint - Get File Properties

Parse JSON - Content (Get File Properties)Full Path

Append to array variable - Name FilePath - Value (Parse JSON)Body

I can't figure out what to put in Parse JSON - Schema

 

Thank you

 
 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-alzhan-msft
Community Support
Community Support

Hi @yanni99 ,

 

You could also add a Compose action to save the variable, and then you could add the Compose dynamic content in the multiline field.

1.png

Best Regards,

Alice

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

6 REPLIES 6
efialttes
Super User III
Super User III

Please, please, Please... share a screenshot from your current flow design

Thanx!



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Json.png

 

Json2.png

Hi!

My suggestion is thefo llowing.

Flow_ParseJSON.png

Please note the labels are in Spanish, when I hover the mouse over them, I can see the following internal names:

[
"FileName": @{body('Get_file_properties')?['{FilenameWithExtension}'],
"Link": @{body('Get_file_properties')['{Link}']
]

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Hi,

Thank you, it seems to be working. But I cannot use my Array variable in my create item/multiline column.  The Variable just doesn't appear.

 

Any pointers? 

Thank you

Hi again!

Try to assign the following expression to your Multiline column

string(variables('outputArray'))

Just replace outputArray and use your variable name insted

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



v-alzhan-msft
Community Support
Community Support

Hi @yanni99 ,

 

You could also add a Compose action to save the variable, and then you could add the Compose dynamic content in the multiline field.

1.png

Best Regards,

Alice

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (64,596)