web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Updating Sharepoint Co...

Power Automate

Answered

Updating Sharepoint Column

(0) Share

Report

Report

Posted on by sean8397

42

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:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-qiaqi@microsoft.com Microsoft Employee 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

Join the conversation