Announcements
Hi @joel914823,Do you want to make the Label5 visible based on the condition?
Please try to set the Visible property of Label5 as:
!IsBlank(LookUp('Issue tracker',Created>= DateAdd(Now(), -24, Hours)&& UniqueIssue=ThisItem.UniqueIssue&& !IsBlank(ITTicketNumber)&& IsBlank(ITTicketResolvedDate) ) )
Hello @v-qiaqi-msft Thank for your help. Apologies, this data is coming from a collection called Issues, so I updated it to that. I'd like for it to be visible if the ITTicketNumber field is not blank ( so I added =false), but the label is still not showing 😞 any help is appreciated.
Hi @joel914823 ,
Are you trying to do this ? Note the structure is for Delegation reasons (I assume you are using SharePoint)
With( { _Item: Filter( Issues, UniqueIssues = ThisItem.UniqueIssues ), _Date: DateAdd( Now(), -24, TimeUnit.Hours ) }, !IsBlank( LookUp( _Item, Created > _Date && !lsBlank(ITTicketNumber) && ITTicketResolvedDate = Blank() ).UniqueIssues ) )
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
@WarrenBelz Thank you so much. I tried to use that but seems the _item piece is giving me some troubles - any ideas?
@joel914823 ,
I mis-typed the bracket type at the top - now amended.
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.
11manish 360 Super User 2026 Season 2
M Bilal Khan 325
Mohsin Ali 232
