i want to create a functionality or workflow so that when an item is added in a list('Status'), it will automatically get added as an option for a choice drop-down field('status') in another list. How i can achieve that?
asked Apr 30, 2020 at 5:20
-
You can use lookup field from first list to another list and use the "Status" column (If it is not choice column in first list)– Ganesh SanapApr 30, 2020 at 5:23
-
@GaneshSanap Actually we are using XSLT dataform webpart in our page which starts giving error when we are changing the type of field to lookup field. So thats why we want to keep as choice field and update the choices from a separate 'status' list– Adarsh AwasthiApr 30, 2020 at 5:25
Add a comment
|
2 Answers
You can do this with workflows.
Just create a list-workflow on List1 which creates a new Item on List2 with the given item values and set the workflow to "Start workflow automatically when an item is created".
for more detailed information, refer to the following article:
https://www.sharepointsky.com/sharepoint-designer-workflow-create-list-item/
answered May 1, 2020 at 4:05
Since you must keep it as Choice, you could create a flow that calls a Sharepoint REST API to update the choice field. There is a question on Stack overflow that seems to explain how to update choice using SharePoint Rest API:
I did not try it myself, so please bear that in mind..
If you feel that Rest API is a good fit, you could create your own for the purpose. You can take guidance at: https://www.c-sharpcorner.com/article/call-rest-api-from-microsoft-flow/
