How to add a record in one Sharepoint List once a filed from another Sharepoint List changed?

(0) Share

Report

Posted on by Chase_Ho

There are 2 sharepoint lists I have on hand, they are:

A: Register the Resignation Requests

B: Recruitment Plan

There is a field name "Approve the Resigantion (Y/N)" in the table "A: Register the Resignation Requests", and once this field changed to "Yes", i want to create a new record on the table "B: Recruitment Plan".

Highly appreciated that if anyone could help!!

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

Hi @Chase_Ho

Here are the steps you need.

You probably need another flag to say that item is created after the Create item flow step. Otherwise it will trigger whenever you modify the Register the Resignation Requests. So add a flag called 'Recruitment Plan Created' Yes/No. Extend the condition to check this flag is No and 'Register the Resignation Requests' is Yes. Update the flag 'Recruitment Plan Created' to Yes after the create flow step. Hope it make sense.

If you need any further help please let me know.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

Thanks

Was this reply helpful? Yes No
Chase_Ho 9 on at

Like (1)

Report

hello Abm,

Would you please also show me how to create a flag to a FLOW to avoid the scenario you mentioned ?

Was this reply helpful? Yes No
Verified answer

v-bacao-msft on at

Like (0)

Report
Hi @Chase_Ho ,

You could refer to the method provided in this blog to get the version value of the specified field, and then check whether the specified field value has changed in different versions.

Microsoft-Flow-Community-Blog/Check-for-a-Change-in-a-SharePoint-List-Column-Value

Use HTTP Request to get the version items, and then get the values of the different versions of the corresponding fields.

Expression reference:

Current Version: body('Send_an_HTTP_request_to_SharePoint')['d']['results'][0]['ColumnName']

Previous version: body('Send_an_HTTP_request_to_SharePoint')['d']['results'][1]['ColumnName']

Image reference:

Also, note that true/false should be used to correspond to Yes/No.

Hope it helps.

Best Regards,

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

Like (0)

Report

Hi @Chase_Ho

Step 1:
SharePoint list settings List A: Add a new column called 'Recruitment Plan Created' type Yes/No check box.
Step 2:
Extend the if condition to check Recruitment Plan Created is false along with other condition as well.
Step 3:
Next after the create item add a flow action step update List A, set Recruitment Plan Created to true.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

Thanks

Was this reply helpful? Yes No