web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Delegation Warning for...
Power Apps
Answered

Delegation Warning for Checking ParseJSON Values in Gallery

(0) ShareShare
ReportReport
Posted on by 300

I am displaying parsedJSON of Excel file to a gallery. I need to check for values of my 'DocumentNo' column if it exists in SP list. If it does, change font to red, if not, keep color.

 

But, I have 'Delegation' warning. I will be working with more than 500 SP items...How do I change the formula to address this? Sorry, newbie here. I read some forums about delegation but have not totally grasp the idea. Thank you!

 

jaanihsm_0-1714152961213.png

 

 

 

Categories:
I have the same question (0)
  • Verified answer
    BhargavPatel Profile Picture
    660 Moderator on at

    @jaanihsm 
    If the DocumentNumber is a text column. Try this:

    If(IsBlank(Text(ThisItem.Value.Title)) ||
    !IsBlank(LookUp('TemplateR2', DocumentNumber = Title2_2.Text)),Color.Red,Color.Black)

     

    If DocumentNumber is a number column, try this:

    If(IsBlank(Text(ThisItem.Value.Title)) ||
    !IsBlank(LookUp('TemplateR2', DocumentNumber = Value(Title2_2.Text))),Color.Red,Color.Black)

     

  • jaanihsm Profile Picture
    300 on at

    Woooorked finally! Thank you so much @BhargavPatel! Much appreciated! 

  • BhargavPatel Profile Picture
    660 Moderator on at

    @jaanihsm You are welcome!

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.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 84

#2
WarrenBelz Profile Picture

WarrenBelz 79 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 40 Super User 2026 Season 1

Last 30 days Overall leaderboard