Unanswered

HTTP Request to SharePoint output help

(0) Share

Report

Posted on by ScoreLord

Hi all,

We have an issue with one of our flows that gets photos from a SP list and email them daily. It has been working great for a couple of months now until today.

After checking the flow we could identify the HTTP request output is now different. Changed without notice. So when parsing the output we get null as it seems different schema.

Photos are stored in a public SharePoint list. We have not made any changes to lists, flow or the SharePoint site.

I have attached screenshots of when the flow worked and when it didn't.

Also below transcript of outputs

When it worked

{

"d": {

"Photo": "{\"type\":\"thumbnail\",\"fileName\":\"c8a181c9-556d-41cd-854d-949ddba10d18.jpeg\",\"fieldName\":\"Photo\",\"serverUrl\":\"https://********.sharepoint.com\",\"serverRelativeUrl\":\"/sites/*********/SiteAssets/Lists/fe6b3173-a6d4-4c3d-be0c-070e7eaafa38/c8a181c9-556d-41cd-854d-949ddba10d18.jpeg\",\"id\":\"25cb0101-c6e6-4e7f-9e2d-fcd8cd2240b4\"}"

}

Without notice output changed to this (please note this is not the same Item as above - different ID)

{

"d": {

"Photo": "{\"fileName\":\"Reserved_ImageAttachment_[5]_[Photo][36]_[efa6c21c-c1fd-4ce4-8234-433b24faed49][1]_[2].jpeg\"}"

}

Can anyone please shed some light and advise what happened here?

Regards,

Percy

Categories:

Using flows

All responses (3)

Answers (0)

Sort by

annajhaveri 8,531 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@ScoreLord i tried similar example in my flow and it gives the original output what you used to get before, can you try with different list item/list or site, to narrow down the issue?
AnotherPPUser 4 on at

Like
a
(1)

Report
Copy link

Link copied!

The same thing happened to me.

I had a few guesses as to what was happening.
One of them was that the file was no longer going to the correct folder. I checked this and, it turns out the files are automatically saving as an attachment.

I disabled attachments on the list settings to force the files to save under Site Assets again, but the output is still different.

The other guess I had comes into this which has something to do with how SP is saving the files. I checked the new saved files, and the dimensions are no longer included in the properties. Not sure how that works, but I think that is why the HTTP output is different.

Still trying to figure this out. I think this may be a Microsoft issue. Hope someone from Microsoft can shed light on this.

Anyway, in the meantime, you can create a new flow to accommodate the new HTTP output.
ScoreLord 5 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi all,

Thanks for taking the time to look into this.

It seems the problem is images are now saved as attachments instead of site assets for some reason. I have only this issue with this SP list, I've tried with different SP list and they are still saved as site assets.

Will have to work with attachements now. Hopefully these changes do not happen again.