Announcements
I have a SharePoint list with a column named "UniqueIssues". I'm trying to figure out a formula where if there are other records (created within the last 24 hours) with the same "UniqueIssues" as in this item , then update the ITTicketNumber field to blank/null.
Hi @joel914823 ,
Probably something like this
With( { _Current: DateAdd( Now(), -24, TimeUnit.Hours ) }, If( !IsBlank( LookUp( 'Issue Tracker', UniqueIssues = ThisItem.UniqueIssues && Created > _Current ).UniqueIssues ), Patch( 'Issue Tracker', ThisItem, ITTickerNumber: Blank() ) ) )
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
MVP (Business Applications) Visit my blog Practical Power Apps
Thanks @WarrenBelz - much appreciated. The item is not patching to blank. Do you think it has something to do with the IsBlank? If the UniqueIssues = Thisitem.UniqueIssues, then replace with blank.
Turn on your Formula Level Error Management in Settings.
Thank you @WarrenBelz The item is not patching to blank. Do you think it has something to do with the IsBlank? If the UniqueIssues = Thisitem.UniqueIssues, then replace with blank.
With({_Current:DateAdd(Now(),-24,TimeUnit.Hours)},If(!IsBlank(LookUp(Issues,UniqueIssues = ThisItem.UniqueIssues &&Created > _Current).UniqueIssues),Patch('Issue tracker',ThisItem,{ITTicketNumber: Blank()})))
@joel914823 ,
If you put this on a Label in the Gallery, do you see true when you expect to ?
With( { _Current: DateAdd( Now(), -24, TimeUnit.Hours ) }, !IsBlank( LookUp( Issues, UniqueIssues = ThisItem.UniqueIssues && Created > _Current ).UniqueIssues )
Hi @WarrenBelz Yes. it's coming back as true when expected so it's picking the record correctly. Is there a way to patch to replace the value to blank. In some cases the field may already be blank or it may have a value in it.
What type of field is ITTicketNumber - if numeric, you may have to Patch zero.
@WarrenBelz it is set up as a single line of text
disregard - This worked, Thank you SO SO MUCH (I could have sworn I turned on Formula level management and apparently it had not saved) @WarrenBelz
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 345 Most Valuable Professional
11manish 207 Super User 2026 Season 2
Mohsin Ali 177
