cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mrleetyler
Resolver I
Resolver I

expression - Update List (SP) if statement if true change text if false ignore and leave column as it was

I have one column in my SP list that will read "Sent" or "Received"

 

i'm running a daily check to see which we users we have received before resetting that column to "Sent" 

 

If we have received i want this new column to read "Received" otherwise i want it to just be ignored and just leave the contents of the column item as it was.

 

this is what i've come up with everything minus the false statement of item()?['1'] works (1 is the new column)

 

if(and(equals(item()?['IncrementEmailDay'],1),equals(item()?['Samples'],'Received')),'Received',item()?['1'])

 

 

if i leave the false statement out it fails, how can i either ignore the false statement or add what is already there back to the item if false.

2 REPLIES 2
eric-cheng
Solution Sage
Solution Sage

Hi @mrleetyler ,

 

I had a similar scenario prior where I used a Get Item By ID earlier in my flow to get the existing values of each column prior to updating.

 

I then used the columns from the Get Item By ID with my false condition which will update the field with the same value.  

 

There may be a more elegant way of doing it thought.

 

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

thats not a bad idea, there has to be an easier way though surely it's not like it's a complicated request

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,391)