Power Platform Community Forum Thread Details

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:

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

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

and the SPLIT Function looks like this:

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):

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):

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:

General topics