Answered

Patch updates collection but not sharepoint list with more than 2000 records

(1) Share

Report

Posted on by RP-05081034-0

I have a sharepoint list (ASPRO Calendar - Stephen) that now has more than 2000 records so I have created a collection (Stephen_col) from two separate filtered collections (Stephen_col_1 and Stephen_col_2) based on an ID column that is present in the sharepoint list. This all works fine.

The sharepoint list/collection populates a power app page that is built to resemble a table with names down the left side and dates up the top but each cell of the table is built up of individual buttons which show some data related to that date and person

The issue I have is these buttons are supposed to change a Choice column in the Sharepoint List (column name = Completed) from either blank or No to Yes and back to No if it is clicked again on an existing record. This Patch formula works fine when I referenced the sharepoint list directly when it had less than 2000 records but once I introduced the collection element it is now not working.

I have created a text label to show the value of the Completed column once the button has been pressed and this does change to Yes or back to No when the button is pressed but the sharepoint list does not get updated

The OnSelect formula for the button is this:

If(LookUp(Stephen_col,Name.DisplayName=HOAP_LM_1.Text && Text(StartTime,"dd/mm/yyyy")=HOAP_Lbl_SundayDate.Text,Completed.Value)="No"||"",
Patch(Stephen_col, LookUp(Stephen_col,ID = LookUp(Stephen_col,Name.DisplayName=HOAP_LM_1.Text && Text(StartTime,"dd/mm/yyyy")=HOAP_Lbl_SundayDate.Text,ID)),{Completed: {Value: "Yes"}}),
Patch(Stephen_col, LookUp(Stephen_col,ID = LookUp(Stephen_col,Name.DisplayName=HOAP_LM_1.Text && Text(StartTime,"dd/mm/yyyy")=HOAP_Lbl_SundayDate.Text,ID)),{Completed: {Value: "No"}}))
 
 
HOAP_LM_1 is a Label with a name in it
HOAP_Lbl_SundayDate is a label with a date in it
 
Any help would be appreciated as I have been searching for an answer for a while for this
 

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Suggested answer

Michael E. Gernaey 53,963 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi,

You are probably having an issue due to Delegation. Possibly in your LookUp due to you using Text conversions.

Can you please show us a screenshot of the Code Window and the Delegation issues you are receiving.

Here is my Guess at your problem without you sharing more.

You are converting a DateTime, to Text so that you can compare that to the Text Value of the SundayDate, but that is not going to be delegatable.

So you need to pre-create that value like this

With( {SundayDateValue: DateTimeValue(InsertedYourTextInputTextHere) }, Now in your Queries, do not use Text to convert StartTime, do StartTime = SundayDateValue // Also note I used DateTimeValue, but you can just do DateValue if you just // want the Date without time. );

Was this reply helpful? Yes No
RP-05081034-0 13 on at

Like (1)

Report
Copy link

Link copied!

Thanks for your response FLMike

I am not getting any delegation warnings on any of the formulas in this box which is the Sunday box (see screenshot below). In the other boxes that don't use the collection reference (Monday to Saturday) I get the following delegation warning for the date text formulas:

Screenshot of formula for Sunday using collection:

Screenshot of formula for Monday using Sharepoint list reference:

Was this reply helpful? Yes No
Verified answer

RP-05081034-0 13 on at

Like (1)

Report
Copy link

Link copied!

I have been shown a simpler method by colleague to achieve the same result which doesn't result in any errors so there is no need to try and solve this one

Thank you for your help

Was this reply helpful? Yes No