cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ALZamora
Helper II
Helper II

Formulas worked yesterday, but not all parts of them today (EDITED)

EDITED: These formulas work for some students, but not all. Makes me think it's a data source issue, but I can't find anything off in my excel tables as I didn't change anything.

 

All my formulas were working yesterday, but not today. Any thoughts? I tried removing my data source which is excel and re-connecting. (examples of formulas below)

 

Ex #1 - the text box is supposed to say "Yes" when the student has been audited and "No" when they haven't. The current selected student has been audited. I checked Table_Audits and Table_Students and the student's name is in both. The combo box is linked to Table_Students. *EDIT: some students with audits it says "Yes," but others with audits it says "no"

selected student audited.JPG

 

 

Ex #2 - once a student is selected, the gallery should populate with all their audits. Then you can select a radio button to filter the gallery to that particular audit type. (formula below) When I preview the app, the gallery doesn't even show on the screen where here it at least shows it without any records. *EDIT: some selected students with audits will populate the gallery, others that also have audits will not

indicator gallery.JPG

SortByColumns(
Filter(Table_Audits,Student=cboxSTUDENTrec.Selected.Student && If(!IsBlank(radio_AUDITTYPErec.Selected.Value),Audit=radio_AUDITTYPErec.Selected.Value,true)),"AuditDate",Descending)

 

Ex #3 - the gallery lists all students and those who have been audited say "Yes" and those that have not say "No". Mickey has not been audited, but the next student has. (formula below for Y/N text box) *Edit: Some students with audits it will say "Yes," but others with audits it will say "no"

student gallery.JPG

If(ThisItem.Student in Table_Audits.Student,"Yes", "No")

 

1 ACCEPTED SOLUTION

Accepted Solutions
ALZamora
Helper II
Helper II

@v-xida-msft  @Mr-Dang-MSFT 

 

I tried the Sharepoint list for the Table_Audits and received the same results of select audited students working. Also, the gallery had the added delegation warning. When the excel is used, there is not a delegation warning.

 

@RandyHayes UPDATE: I've increased my limit to 2000 which has fixed my problem for now. I anticipate there being over 2000 records in the near future, so what would solve that problem? I can keep the SP list for the audit table if that would make the solution easier as it can be delegated. Thanks!

 

 

View solution in original post

5 REPLIES 5
Mr-Dang-MSFT
Power Apps
Power Apps

Hi @ALZamora ,

In the formula bar, did you see an error that said something about delegation? The issue you're encountering is that the data source is hitting a limit on how many records it can read and return because the filters are not being 'delegated' to the service. There are forum posts on this topic that you can search for with the keywords 'delegation.'

 

Depending on where your data is stored, the forum members who are experts on Filters and LookUps can help here.

 

@LRVinNC @RandyHayes 

v-xida-msft
Community Support
Community Support

HI @ALZamora ,

Based on the formula that you provided, I do not find any syntax error with it.

 

I have made a test on my side, and don't have the issue that you mentioned. Based on the issue that you mentioned, I think this issue may be related to your Excel table data source.

 

Please consider take a try to re-create your two Excel tables -- Table_Audits1 and Table_Students1, the copy data from your previous Excel table into the new created Excel table individually.

Then re-create a new app based on above new created Excel tables, then try your formula again, check if the issue is solved.

 

If the issue still exists, please consider store your data within SP list instead of your Excel table, then try it again, check if the issue still exists.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@v-xida-msft  Just tried recreating the tables in excel and testing in a new app. Same issue. Will work on switching to a SP list which was something I was considering due to the large volume of audit records.

@Mr-Dang-MSFT  I didn't see a delegation error, but will look up those posts to see if that may help. Thank you!

ALZamora
Helper II
Helper II

@v-xida-msft  @Mr-Dang-MSFT 

 

I tried the Sharepoint list for the Table_Audits and received the same results of select audited students working. Also, the gallery had the added delegation warning. When the excel is used, there is not a delegation warning.

 

@RandyHayes UPDATE: I've increased my limit to 2000 which has fixed my problem for now. I anticipate there being over 2000 records in the near future, so what would solve that problem? I can keep the SP list for the audit table if that would make the solution easier as it can be delegated. Thanks!

 

 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on June 15, 2022 at 8am PDT.

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Top Kudoed Authors
Users online (2,487)