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

All responses (3)

Answers (0)

TarunaM 51 on at

Like (0)

Report

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

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
TarunaM 51 on at

Like (0)

Report

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

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
ManishSolanki 15,085 Super User 2025 Season 1 on at

Like (0)

Report

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

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