Unanswered

Send HTTP request to update yes/no column in sharepoint not actually changing column on success

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

This is a wierd on for me. I have an Send HTTP request to update a Yes/No column in SharePoint. When I run the flow it runs successfully, I look at the run history of the flow and the action displays the check mark image, yet when I look at the sharepoint list and view the column of the item the flow ran on, the column is unchanged. How can this happen? I have my configurations and result images below.

Send HTTP request action;

Flow result;

SharePoint list;

I have also tried False and I got the same result.

Anyone know if this is a bug or a fix for this?

I appretiate any suggestions.

DWTKBrook

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Expiscornovus 33,830 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @Anonymous,

The value 0 as string should be correct. Just tested it in my dev environment.

Only two things which I see is different is that you haven't included Headers in your action and the body is missing the bNewDocumentUpdate property in the payload. Might be worth a shot to add those as well?

Below was my test btw

Headers

{ "Accept": "application/json;odata=verbose", "Content-Type": "application/json;odata=verbose" }

Body

{ "formValues": [ { "FieldName":"ViewUpdated", "FieldValue":"0" } ] ,"bNewDocumentUpdate":false }

Test results of three runs with both "0" and "1" as values.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello @Expiscornovus - This is very odd indeed, I edited the Send HTTP request as per your advice (image below)
The version history records the change (below);

The hyperlink column called view is updating as expected but the check mark (even after many refreshes), the check mark is still visible;
Very strange behavior.

Was this reply helpful? Yes No
Expiscornovus 33,830 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous,

Couple of things to check. Is the internal name of the field ViewUpdated? Have you double checked this?

https://elliskarim.com/2021/12/20/finding-the-internal-name-of-a-sharepoint-column/#method-1-column-settings

Can you also try to only update the ViewUpdated field in your request. Just to see if it is a multiple fields at once kind of issue.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello @Expiscornovus

Yes, I have double/triple check the internal column name. I removed the the update in the action and it worked. I then added it back, only this time I had the ViewUpdated column first and the hyperlink column after and it is now working as intended. It look like is seems to need a specific order.

Thanks for all your help on this one.

Cheers!
DWTKBrook

Was this reply helpful? Yes No