Views:

Applies to Product - Power Apps

What’s happening?
The customer is unable to retrieve file paths using the LookUp function in their document library. The function was previously working but has stopped functioning as expected.
 

Reason:
This is likely caused by the number of documents in the document library exceeding the limit of 2000 records that can be retrieved by the LookUp function in the canvas app.
 

Resolution:

  1. Confirm that the number of documents in the document library is below 2000.
  2. If the number of documents exceeds 2000, consider using the Filter function to extract records before applying the LookUp function.
  3. Ensure that the LookUp function is correctly formatted as follows: LookUp(Documents, "Shared Documents/General/保存/" & ThisItem.Key_PNo & ".pdf" = ThisRecord.'完全パス', ThisRecord.アイテムへのリンク)
  4. If the issue persists, check the settings of the app and consider changing the creation version of the app to see if it resolves the issue.