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
2. One item is added, please note Leave Type is "SL - Sick Leave"
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.
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"
What's the solution so that Leave Type doesn't change and remains same.
TIA
Solved! Go to Solution.
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
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
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
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
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. Sharepoint Update Item in flow, where I can't find choice field "Ltype"
Hi Mona, there seems to be problem in the list, I recreated the list and applied the flow, its working fine now, thanks.
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
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.
User | Count |
---|---|
89 | |
57 | |
40 | |
39 | |
35 |
User | Count |
---|---|
79 | |
66 | |
57 | |
52 | |
42 |