Patch SharePoint list

[AshishJaiswal]

Hello

I'm looking for a way to patch existing item in sharepoint.

But I'm not sure how to relate to the existing item or perform some kind of lookup to find existing item and update it.

[RandyHayes]

@AshishJaiswal 

If that is the case, then your LookUp is not matching a record based on the criteria.  It is very possible that User().Email is providing a letter cased value that is different than the one stored in the list.

Change this part of your formula:

   LookUp('List A1','Modified By'.Email = currentEmail),

To:

   LookUp('List A1', currentEmail in 'Modified By'.Email),

[AshishJaiswal]

@RandyHayes @Pstork1 

You are genius !!!
Without you guys, I would have never been able to achieve this.

It works- It is updating the existing entry 

But I get a warning

[RandyHayes]

@AshishJaiswal 

Yes, I should have mentioned that you will get a delegation warning as the in operator is not delegable.

However, it was really more of a text to determine if, in fact, the letter case of the emails was the culprit.  Since it worked, then this is the issue.  

If you put a label on the screen and set the Text to : User().Email and then look at the email in the list for the Modified By column, you will see that there is a letter case difference.

Now, as for the delegation warning...if your list is less than 2000 records and not expected to exceed that, then you can ignore this warning completely.  If not, then we need to look at other alternatives.

[AshishJaiswal]

@RandyHayes 

True 

In sharepoint column  I see name 

But in Label I see

My Sharepoint will have more than 5000+ items 😥😥😪

Please advise 

[RandyHayes · Accepted solution]

@AshishJaiswal 

So then the real test from the SharePoint side would be to hover or click on the name in the column.  Then you will see the actual email address.  My guess is that it is still a different case.

You can also do this:

   LookUp('List A1', StartsWIth('Modified By'.Email, currentEmail),

It is not case sensitive and should solve it.

[AshishJaiswal]

@RandyHayes 

Thank you, It works like a charm - If we ever met in the future - I will buy you beers all 7 days a week

[AshishJaiswal]

thanks

[RandyHayes]

@AshishJaiswal 

7 Day a week beer is my kind of thing...so we must meet up soon! 😁

Glad it all worked.