Powerapps Lookup Not Working

(0) Share

Report

Posted on by MikeWJS

Hi,

I have built a function to do a lookup on a SP list (no delegation warnings present).

The list has 7 columns and about 2800 rows.

The function is,

LookUp(Barcodes, BC = Value(TextInput1.Text),Product)

If I try to lookup, the first 50 or so barcodes, the lookup works perfectly with the following,

{
 "status": null,
 "duration": null,
 "dataSource": "Barcodes",
 "responseSize": null,
 "controlName": "Label1",
 "propertyName": "Text",
 "nodeId": 9,
 "formulaData": {
 "script": "LookUp(Barcodes, BC = Value(TextInput1.Text),Product)\r\n",
 "spanStart": 0,
 "spanEnd": 53
 },
 "data": {
 "context": {
 "entityName": "Label1",
 "propertyName": "Text",
 "id": 53,
 "nodeId": 9,
 "diagnosticContext": {
 "dataOperation": {
 "protocol": "cdp",
 "operation": "showGetRowsCount",
 "apiId": "/providers/microsoft.powerapps/apis/shared_sharepointonline",
 "dataSource": "Barcodes",
 "table": "da3e3d08-545e-4ab3-86ef-b71ca306d9ab",
 "operationName": "getRowsCount"
 },
 "formula": "LookUp(Barcodes, BC = Value(TextInput1.Text),Product)\r\n",
 "span": {
 "start": 0,
 "end": 53
 }
 }
 },
 "info": "Requested 1 rows. Received 1 rows."
 }
}

However, if I try anywhere past the first 50, it doesn't work and I get the following,

{
 "status": null,
 "duration": null,
 "dataSource": "Barcodes",
 "responseSize": null,
 "controlName": "Label1",
 "propertyName": "Text",
 "nodeId": 9,
 "formulaData": {
 "script": "LookUp(Barcodes, BC = Value(TextInput1.Text),Product)\r\n",
 "spanStart": 0,
 "spanEnd": 53
 },
 "data": {
 "context": {
 "entityName": "Label1",
 "propertyName": "Text",
 "id": 61,
 "nodeId": 9,
 "diagnosticContext": {
 "dataOperation": {
 "protocol": "cdp",
 "operation": "showGetRowsCount",
 "apiId": "/providers/microsoft.powerapps/apis/shared_sharepointonline",
 "dataSource": "Barcodes",
 "table": "da3e3d08-545e-4ab3-86ef-b71ca306d9ab",
 "operationName": "getRowsCount"
 },
 "formula": "LookUp(Barcodes, BC = Value(TextInput1.Text),Product)\r\n",
 "span": {
 "start": 0,
 "end": 53
 }
 }
 },
 "info": "Requested 1 rows. Received 0 rows."
 }
}

Has anyone any idea what is happening here please?

Thanks,

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@MikeWJS

First, take the Value(TextInput1.Text) out of the equation and "hard-enter" an actual number there for the record that is beyond the 50 record count and see if that returns a record.

If that does, then your formula is not delegating. If it does not, then there is some other issue as it is not finding the record.

I hope this is helpful for you.

Was this reply helpful? Yes No
MikeWJS 88 on at

Like (0)

Report

Many thanks for your response Randy!
I think you were on to something with delegation.
This issue was on an app I am developing which didn't work so I recreated a simple app with just the above in it and I think I have found the issue, it appears to be related to the copy and paste within Sharepoint online.
When entering data 50 lines at a time, you can see sharepoint importing them line by line and all is good, except sometimes it freezes and you have to refresh and paste in the missing records.
If you try to do it en-masse (2000 records at a time?) it doesn't appear to step through them and the page becomes massively unresponsive (even if you leave it for a long time!).
Doing it slowly, 50 at a time I got right up to 550 records (above the default 500) which proves delegation works and is stable if the data is entered slowly.

Hopefully this wont be an issue in the main app as the data will be pulled from Excel via PowerAutomate, or do you think I may run into the same issues? I would be interested if anyone else has run into anything such as this?

Was this reply helpful? Yes No