cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

approval workflow - updating field issue

I have a approval work flow to manage "Leave Request" I have sharepoint list where user input their details, this initiates the workflow, send email for approval to manager, who either approves or rejects its,

Once this is done, workflow updates a field "Status" based on manager response.

 

When above step is done, this flow updates another field "Leave Type" which field type is Choice, data in this field is removed all together, how do I fix it, below are snapshots, which would give you clear idea on this issue.

 

1. "Leave Type" - this field type is choice


1_LeaveType_Choice.JPG

 

 

 

 

 

 

 

 

 

 

2. One item is added, please note Leave Type is "SL - Sick Leave"

 

2_SL_Applied.JPG

 

 

 

 

 

 

 

 

 

 

 

 

3. When above list is approved, and workflow updates status to Approved, note that Leave Type field is blank.

This should not happen as Leave Type field is choice, which isn't supported in flow, but its updating this field.

 

3_Approved_WF_deletes_LeaveType.JPG

 

 

 

 

 

 

 

 

 

 

4. Here is the workflow, which kicks off once manager approves, note that I'm only updating mandatory field and status field, but this is impacting "Leave Type"

4_Updated_Status_inWF.JPG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

What's the solution so that Leave Type doesn't change and remains same.

 

TIA

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Community Support
Community Support

Re: approval workflow - updating field issue

Hi Medasbabu,

 

From your screenshot, I noticed that there is no Leave Type column shown in "SharePoint- Update item" action. I think this is the reason why this column value will change after flow runs.

 

Please check, if we create a new flow and connection to this list, will the Leave Type column show in the SharePoint action field? If no, please try to recreate a new "Leave Type" choice column to then test in flow to see if the new one can show successfully.

 

I have created a choice column in my SP list and create a similar flow like yours. I'm not getting your issue as long as I filled the  choice column value with the right dynamic content from previous action.

 

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.

View solution in original post

Highlighted
Frequent Visitor

Re: approval workflow - updating field issue

Thanks Mona, the reason I wasn't expecting "Leave Type" in flow because flow doesn't support choice field, that's what I understood when i searched to resolve this, but you state, you were able to update choice column in flow, let me test it out.

 

Thanks

Suresh

View solution in original post

5 REPLIES 5
Highlighted
Community Support
Community Support

Re: approval workflow - updating field issue

Hi Medasbabu,

 

From your screenshot, I noticed that there is no Leave Type column shown in "SharePoint- Update item" action. I think this is the reason why this column value will change after flow runs.

 

Please check, if we create a new flow and connection to this list, will the Leave Type column show in the SharePoint action field? If no, please try to recreate a new "Leave Type" choice column to then test in flow to see if the new one can show successfully.

 

I have created a choice column in my SP list and create a similar flow like yours. I'm not getting your issue as long as I filled the  choice column value with the right dynamic content from previous action.

 

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.

View solution in original post

Highlighted
Frequent Visitor

Re: approval workflow - updating field issue

Thanks Mona, the reason I wasn't expecting "Leave Type" in flow because flow doesn't support choice field, that's what I understood when i searched to resolve this, but you state, you were able to update choice column in flow, let me test it out.

 

Thanks

Suresh

View solution in original post

Highlighted
Frequent Visitor

Re: approval workflow - updating field issue

Hi Mona, I created a test list with similar fields and created a flow to update the list, nope, I was not able to see choice filed in that flow.

 

1. List containing choice field Ltype.2_1_Ltype_ChoiceField.JPG

 

 

 

 

 

 

 

 

 

 

 

 

2. Sharepoint Update Item in flow, where I can't find choice field "Ltype"2_2_UpdateItem.JPG

 

 

Highlighted
Frequent Visitor

Re: approval workflow - updating field issue

Hi Mona, there seems to be problem in the list, I recreated the list and applied the flow, its working fine now, thanks.

Highlighted
Community Support
Community Support

Re: approval workflow - updating field issue

Hi medasbabu,

 

Great to know that the issue is solved. If there are some changes in SharePoint list, it might effect the flow to work properly.

 

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.

Helpful resources

Announcements
firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (8,542)