web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Need Help With JSON pa...
Power Automate
Unanswered

Need Help With JSON parsing to add multiple attachments to a SharePoint List Item

(0) ShareShare
ReportReport
Posted on by 109

Hi PA Community,

 

I'm reasonably new to PA and a complete and utter newb when it comes to JSON. I need to use the Parse JSON action in PA to connect to a proprietary application and send new enquiry's from the proprietary application to a SharePoint List.

 

So far I have the enquiry's being pushed into the SPL but when PA gets to the attachments, I'm getting a data type mismatch error (getting an array and expecting a string) in the SPLIT function I'm using.

 

Here is the portion of the JSON schema associated with the attachments:

geddb_0-1692327498961.png

As you can see the object is of type 'array'

 

Here is the PA flow that's handling the attachments:

geddb_5-1692328122504.png

 

 and the SPLIT Function looks like this:

 

geddb_2-1692327660961.png

When the flow is triggered with an enquiry that has ONE attachment I get the datatype mismatch error in the SPLIT function (expecting a string and getting an array):

geddb_7-1692328408513.png

 

and when the flow is triggered with an enquiry that has MORE THAN ONE attachment I get a different error in the Check For Attachments Action (expecting a string or array and getting Null):

 

geddb_4-1692327891471.png

 

So what I need to understand is how to take a JSON payload from the proprietary system and map an array inside of that JSON schema to deliver multiple attachments to a SPL Item. I'm feeling a little like Alice tumbling down the rabbit hole here and could really use some direction if anyone can assist.

Thanks in advance.

GB.

Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 86 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 55

#3
Ellis Karim Profile Picture

Ellis Karim 53 Super User 2026 Season 1

Last 30 days Overall leaderboard