Answered

Approval workflow Sharepoint List Field Update

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I am new to Sharepoint and Flow. I am creating a Leave Request Approval. I was able to create the request, the flow to send an approval message, and the email sent to the employee with the Accept or Refused. I want the Sharepoint List to be updated with this response. How can I have the Sharepoint status field updated with the response sent via Work Flow?

Categories:

Building flows

I have the same question (0)

All responses (22)

Answers (1)

abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous,

If your SharePoint status is choice field type then it is not supported for the updates from flow. This is a limitation in current SharePoint flow templates and infurture we are hoping to get this resolved. There are similar posts around in this forum mentioned about choice field SharePoint item updates.

Thanks

Was this reply helpful? Yes No
v-yamao-msft Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!

Hi Kath,

Say you have a SharePoint list likes below. The Approve Status is a Text column.

Then I create a flow to send an Approval email when a new item is created, then send an email with the Accept or Reject status, then update item in the list. Below is a screenshot of the flow configuration:

Hope this can be a reference for you.

Best regards,
Mabel Mao

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks for your answer.

Here is the list that I have created. The colomn "Approval Status" was not created by me. It is added automatically by the system. The status change to pending when the request is send, but it doesn't change when the request is approved or rejected by supervisor.

Also, in the Versioning setting, I selected:
Require content approval for submitted items?
Yes

The flow is still not working.

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous,

Can you please check the list settings and find more about the Approval Status column? Most likely it is not a text field. Please let us know.

Thanks

Was this reply helpful? Yes No
v-yamao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Kath,

Just as @abm said, please check the type of Approve Status column. I have created a similar list with you, but there is no “Approve Status” column was added automatically by the system.

If I create a Choice column “Approve Status” in the list, when I configure the “Update item” action in the flow, there is no field for “Approve Status”. It seems that Choice column type is not supported in flow.

Best regards,
Mabel Mao

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

I was able to fix the problem by removing the Versioning setting and set it to "no". Now the colomn is updating. Thank you!

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous,

That is good news and letting us know. Can you please confirm that it was a text field or not?

Thanks

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

The added colunm by the system is not in the list. So, I don't know if it is a text field.

Was this reply helpful? Yes No
Jazzy 6 on at

Like (0)

Report
Copy link

Link copied!

This solution worked perfectly for me! We just need to get the communication formatting down. I want to train others on this!

Was this reply helpful? Yes No
Tskauffmani 4 on at

Like (1)

Report
Copy link

Link copied!

Would you be so kind to share a screen shot of your expanded Approval FLOW.

I set versioning to "NO" but still can't get Approval Status to switch from "Pending" to "Approved/Rejected". Besides this issue my Flow runs fine.

thanks
@Kath wrote:
I was able to fix the problem by removing the Versioning setting and set it to "no". Now the colomn is updating. Thank you!

Was this reply helpful? Yes No