Unanswered

Ghost entries in my sharepoint list.

(0) Share

Report

Posted on by LordGrim

Hello,
I have a Powerapp which writes data to a sharepoint list, I have an option to see how much work was done for an item. Recently I noticed entries are showing work progress for those item, but in sharepoint list there are no records for those two item.
I am using this formula to calculate and see the work progress of an item.
Round((Sum(Filter(DailyReport, 'Item Code' = ThisItem.'Item Code'), 'Work Done')/ ThisItem.Quantity) * 100 , 2) & "% Completed"

Since I am using "sum" operation and my data source is a sharepoint list. I am getting a delegation warning.
I have increased the limit to 2000.
Any idea what is causing this?

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (0)

WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report

Hi @LordGrim ,
Sum() is not a Delegable and increasing a limit will not take away the warning. It should work OK within your limit set, but bear in mind there is nothing to stop you adding more records after this (hence the warning).

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.

Was this reply helpful? Yes No
LordGrim 49 on at

Like (0)

Report

Hello @WarrenBelz
My question is why the app is showing two item with progress, when there are no entries related to those two item?
What is causing it?

Was this reply helpful? Yes No
WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report
Hi @LordGrim ,
Your code
Round( ( Sum( Filter( DailyReport, 'Item Code' = ThisItem.'Item Code' ), 'Work Done' )/ ThisItem.Quantity ) * 100 , 2 ) & "% Completed"
produces a Text value result - how are you writing this to SharePoint?

Was this reply helpful? Yes No
LordGrim 49 on at

Like (0)

Report

Hello @WarrenBelz
The output for that code doesn't get written in sharepoint directly, it only shows the result in powerapps.
And the value of workdone is written as number in sharepoint list column.
ThisItem.Quantity is a single line text column.
ItemCode is the title column.

Was this reply helpful? Yes No
WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report
Thanks @LordGrim ,
OK the code produces results when it should not?
For a bit of debugging, put some labels on the screen with the following
First( Filter( DailyReport, 'Item Code' = ThisItem.'Item Code' ) ).'Work Done'
and
ThisItem.Quantity
If there are values in both, you will get output from the code. Let me know the results.

Was this reply helpful? Yes No
WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report

Hi @LordGrim ,
Just checking if you got the result you were looking for on this thread. Happy to help further if not.

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.

Was this reply helpful? Yes No
LordGrim 49 on at

Like (0)

Report

Hello @WarrenBelz ,
Sorry for the late response, I was busy with other stuff.

When I entered "ThisItem.Quantity" in the labels Text value I get this error "Name isn't valid. Identifier not recognized."
And for this
"First(Filter(DailyReport, 'Item Code' = ThisItem.'Item Code')).'Work Done'" I get "Invalid aurgument type"

Was this reply helpful? Yes No
WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report

@LordGrim ,
Sorry I meant to say to put them inside the form (in any card) or gallery you are using to refer to them.

Was this reply helpful? Yes No
LordGrim 49 on at

Like (0)

Report

Hello @WarrenBelz
I have the results, there in number 36 it shows some value but there shouldn't be any value for that item, why is it there?
Do you need any other info?

Was this reply helpful? Yes No