Outlook attachment Json data to Sharepoint list not working

[DanielVegaG]

It seems that it should be working, I have set a flow to get the Data from the (Json) attachment and transfer the data to a Sharepoint list, however I keep getting the following error:

The flow is set as follows:

It seems as there is no file attachment to be found, however there is (looking for the Attachment ID in the test flow it finds data).

[v-litu-msft]

Hi @DanielVegaG,

I have some information about your Flow need to confirm:

1. What's the attachment file type? Is it a text file or json file?

2. Two of them all contain JSON data?

You could try to add a Get attachment action to get the content bytes, then check the output if json format.

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

[DanielVegaG]

Tried both Test.JSON and Test.txt, neither worked.

Hmm, I've done the Get Attachment as suggested and the contenbytes is as follows:

ew0KICAidmVyemVrZXJkZSI6ICJCMkJpa2UgbGVhc2UiLA0KICAia2xhbnRiZWRyaWpmIjogIlBNViIsDQogICJnZWJydWlrZXIiOiAiR2VlcnQgR2xvcmlldXgiLA0KICAibWVya19maWV0cyI6ICJTdHJvbWVyIiwNCiAgImZyYW1lbnVtbWVyIjogIlRCTlNUNVM3MDNTTE0wMzY5IiwNCiAgInNsZXV0ZWxudW1tZXIiOiAiWDIyNjM0NSIsDQogICJjYXRlZ29yaWVfZmlldHMiOiAiU3BlZWRwZWRlbGVjIiwNCiAgImJlZ2luX2RhdHVtIjogIjIwMjAtMTItMzEiLA0KICAiZWluZF9kYXR1bSI6ICIyMDI1LTEyLTMwIiwNCiAgInZlcnpla2VyZGVfd2FhcmRlIjogIjYzNTEuMDMiLA0KICAib21uaXVtIjogIm9tbml1bSAzIGphYXIiLA0KICAiQkFfUE9MSVMiOiB0cnVlLA0KICAiRUJHIjogZmFsc2UsDQogICJlbWFpbGFkcmVzX2dlYnJ1aWtlciI6ICJnZWVydC5nbG9yaWV1eEBwbXYuZXUiLA0KICAiYWRyZXNfZ2VicnVpa2VyIjogIlNpbnQtQW5uYXN0cmFhdCAyNiIsDQogICJwb3N0bnVtbWVyX2dlYnJ1aWtlciI6ICI5NjMwICIsDQogICJnZW1lZW50ZV9nZWJydWlrZXIiOiAiWndhbG0iLA0KICAiZ2Vib29ydGVkYXR1bV9nZWJydWlrZXIiOiAiMTk2Ni0wOS0xNiIsDQogICJkYXR1bV9yaWpiZXdpanNfZ2VicnVpa2VyIjogIjE5ODYtMDQtMjEiLA0KICAiZmlldHNoYW5kZWxhYXIiOiAiRmlldHNlbiBGaWVsZXMiLA0KICAidGFhbCI6ICJOIiwNCiAgIm51bW1lcnBsYWF0IjogIlNQQ0E5MjYiDQp9

Not exactly JSON format...

I have saved a .txt file with the JSON content and named the file "Test.JSON" (JSON as the extension), this is the content:

{
  "verzekerde": "xxx",
  "klantbedrijf": "xxx",
  "gebruiker": "xxx",
  "merk_fiets": "xxx",
  "framenummer": "xxx",
  "sleutelnummer": "xxx",
  "categorie_fiets": "xxx",
  "begin_datum": "xxx",
  "eind_datum": "xxx",
  "verzekerde_waarde": "xxx",
  "omnium": "xxx",
  "BA_POLIS": true,
  "EBG": false,
  "emailadres_gebruiker": "xxx",
  "adres_gebruiker": "xxx",
  "postnummer_gebruiker": "xxx",
  "gemeente_gebruiker": "xxx",
  "geboortedatum_gebruiker": "xxx",
  "datum_rijbewijs_gebruiker": "xxx",
  "fietshandelaar": "xxx",
  "taal": "N",
  "nummerplaat": "xxx"
}

[v-litu-msft]

Hi @DanielVegaG,

Thanks for your come back. You could use the base64ToString() function convert the attachment content bytes, then use JSON() function convert the string to JSON, then create item, for example:

base64ToString(outputs('Get_Attachment_(V2)')?['body/contentBytes'])

json(outputs('Compose'))

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

[DanielVegaG]

Thanks for the swift feedback, have set the flow as recommended, now I'm getting the following error on the compose bit:

[Paulie78]

For the purposes of clarity, before I respond to why the above is happening. Can I just make sure of these things:

• You are receiving a JSON attachment in an email.
• You want to parse that JSON to perform an action on SharePoint?

Can you tell me, when this email is received, is there only ever one attachment, or could there be multiple attachments?

[DanielVegaG]

Correct.

Normally only one attachment will be sent at all times. I have noticed that the Flow also captures an image inside an email as an attachment but when the flow will be used, it will be a blank email (tested with completely blank emails with only a Test.JSON file).

[Paulie78 · Accepted solution]

ok, take a look at this flow, somewhat more simple than your one. It might give you some ideas. This works on the basis of only one attachment so selects the first attachment instead of going into a loop.

https://ibb.co/PmCfH6Q

I put this into my source JSON file:

{
	"Title": "0000674",
	"Customer_x0020_Name": "Paul Test Customer",
	"Email_x0020_Address": "paul@powerautomate.com"
}

And was able to create a new item in SharePoint no problems.

[DanielVegaG]

Thanks, this one did the trick for me and it worked after that, not sure what I was doing wrong, however thanks for this!

[kevinneu]

I have tried to put this solution in place, and a running into a problem with the Get Attachment (V2) step. When I add Message Id to to the Message Id field, it suddenly creates and Apply to each step and places Get Attachment (V2) within it, and this seem to not allow the flow to succeed. 

I get a bad request error: https://ibb.co/QYgv4Pr

Here's the part of the flow, up to the point it fails: https://ibb.co/kXgyhH3

I can't find any way to add the items as displayed in your sample - what am I missing? 

[Paulie78]

In the get attachment(v2) action you need to put the output of the action getAttachmentID, not the messageID from the trigger.