Answered

Delegation Warning for Checking ParseJSON Values in Gallery

(0) Share

Report

Posted on by jaanihsm

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!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

BhargavPatel 660 Moderator on at

Like (1)

Report
Copy link

Link copied!
@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)

Was this reply helpful? Yes No
jaanihsm 300 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
BhargavPatel 660 Moderator on at

Like (0)

Report
Copy link

Link copied!

@jaanihsm You are welcome!

Was this reply helpful? Yes No