SharePoint list A to append distinct record to SharePoint List B based on criteria

(0) Share

Report

Posted on by TarunaM

Hello Experts,

I had earlier posted the same query but I could not get it resolved. Below I have added the List A and List B .

I require, when a new record is created in List A until the status changes to UD it remains in List A. Once the Status is UD it creates a line item in List B.

When there is an update in List A for a UD Status record then List B to be updated for that particular line item record.

List A has project repeated multiple times but only one record to be created in the List B.

I have added the trigger, when an item is created or modified. @Settings Trigger @equals(triggerbody()?['Project_x0020_Status']?['Value'],'UD').

Result of Current Flow :The issue that I am seeing is, every time I update the project it adds as a new line item in List B.

Kindly explain what step I am missing.

Thanks

Taruna

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (0)

Report

Hi @TarunaM

It seems that 'Get items' does not return any records and the length of record count is always zero so it create a new list item.
Pls try modifying the Filter Query in 'Get items' action as per below screenshot:
assuming Project is the column in List B to identify the records.

If this helps & resolves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
TarunaM 51 on at

Like (0)

Report

Hello Manish,

Under Get items List B is Metrics-EOI and Active Projects and Quarterly Budget
Project ID schema field_0
List A Project ID Schema field_5

output List B still getting all entries instead of one record.

Thanks
Taruna

Was this reply helpful? Yes No
TarunaM 51 on at

Like (0)

Report

On second thought, Is this doable
List A a user enters 4 records same Project ID but unique participants for that project. Once the status changes to UD then the flow to first check if that Project ID is not in List B then in List A look for unique record by Project ID and create that record in List B and update fields Project ID, Title, Project Status. I can get rid of the update part.

let me know
Thanks
Taruna

Was this reply helpful? Yes No