cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
StuartSSTech
Advocate I
Advocate I

SharePoint Update List Item Approval Status Column

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

 

Missing Approval Status.PNGMissing Approval Status 2.PNG

6 REPLIES 6
Satyam_Gupta
Helper I
Helper I

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

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

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
Community Support
Community Support

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

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

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
Helper II
Helper II

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.

 

flow1.PNGflow2.PNGflow3.PNGflow4.PNGflow5.PNGflow6.PNGflow7.PNGflow8.PNG

 

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

Hope this helps!

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (3,081)