Updating Sharepoint Column

(0) Share

Report

Posted on by sean8397

Hi,

I'm trying to update my IsActive column in sharepoint to "yes" if a new item is created. I then want the old rows that shares the same SWO Number to change to "no".

So far I have been able to change IsActive to "yes" but I'm having difficultly changing the old rows to "no". Below are some pictures of what I have:

Sharepoint (4247 is the SWO Number and the last row should be the one that's checked and no other rows):

Thank you!

Categories:

General topics

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report
Copy link

Link copied!
Hi @sean8397,

Do you want to update the IsActive with yes for the new created item but you want to update the IsActive withn no for the existing old rows that shares the same SWO number?

If so , I think you should filter based on Modified and SWO:

Here is the expression you should write in advanced mode from Filter array:

@and(equals(item()?['SWO'], triggerOutputs()?['body/SWO']),not(equals(item()?['Modified'], triggerOutputs()?['body/Modified'])))

Was this reply helpful? Yes No