cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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

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

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

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

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

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

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

Highlighted

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

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (7,525)