SharePoint Update List Item Approval Status Column

[StuartSSTech]

Good Afternoon...

I think im going to be posting alot as i start to try build some New Flows as its very limiting when it comes to SharePoint.

Today i seemed to have found a bug thats driving me a bit crazy.

Running an approval on a New Item being Added, then all i want to do is update the OTB Approval Status Column to match the outcome but the option does not appear for me and i have seen other threads having to build a custom column to resolve this. 

This should be standard and OTB with the existing SharePoint Features.

Any advice on whether this is a known issue or bug.

Kind Regards

Stuart

[Satyam_Gupta]

Hi @StuartSSTech

Approval Status column internally a Choice type column and microsoft flow does not support Choice column,Hyperlink column and lookup column.Microsoft working to provide support all type of column,I think in next version of they provide for all type column. 

Thanks,

satyam

[StuartSSTech]

Thanks Satyam...

Benn trying to find offical confirmation on Fast track for when updates are coming as flow right now isnt proving to be ready for SharePoint yet.

Thanks again for your reply ill move on for now and postponse what im trying to achieve. Have a few issues but one at a time 🙂

Stuart

[Satyam_Gupta]

Hey @StuartSSTech,

No issue, you can post your all queries if i am capable to resolve your query then definitely i will reach to you wtih solution.

Thanks,

satyam

[v-monli-msft]

Hi,

Here is an idea submitted on this:

SharePoint Choice List Missing

Please vote for it if you would like the choice fields to be supported soon, and if you have any further questions, please feel free to post back.

Regards

Mona

[Nikhil]

Hi, 

I am facing the same issue. 

Do you know if Microsoft has not fixed the issue yet. 

I have seen many videos with the demonstration of approval column but not able to get in my own environment.

Regards, 

Nikhil Tiwari

[Lexnnn]

I have an approval list for creation of new O365 groups.

I wanted to approve the list items directly from the email using flow.

I tried out myself but for some reason it did not work but using the method described below, I was able to do it. Thank you to the author!

Found this solution: https://www.techmikael.com/2018/05/use-microsoft-flow-to-implement.html#comment-form

I tried it out, I also works for me for approval of Sharepoint list items. Really helpful since microsoft has not implemented list items in "set content approval status".

Note: this solution is for Lists where Approval is enabled and the field is not a manually created field but maintained by the system so you can not use it in Flow.

Note: the approval process can take some time, for test purpose, wait multiple hours, first time took time for some reason, now it works fine.

Note: In "set content approval status", in Library name use List name but not the one from the URL

eg. https://...sites/teamsites/team-orders and the list name is Team orders, use Team orders as library name and not team-orders.

Don't know if all these steps are needed but it works for me.

Hope this helps!