Error - "This lookup function is not supported for this data source"

[arosario]

Getting the following error - Error - "This lookup function is not supported for this data source" even if there are records in the collection.

Client has connection inconsistencies at their site.

Because I want my app to work offline, I'm uploading all the data from SharePoint into a couple of Collections within the app. All the forms and Galleries are linked to the Collections and I'm using the Patch function to send the data back to the SharePoint List when the device has a connection. In addition, the data is cached in the device in the event that they start the App without a connection.

[v-yutliu-msft]

Hi @arosario ,

According to your description, your data source is sharepoint list, am I right?

Usully, in sharepoint list, you could use lookup function.

So, I think maybe the problem is about your formula.

Could you show me your formulas in details?

Best regards,

[arosario]

The data source for the form (frmTankInspection) and gallery (InspectionGallery)  is a collection (CurrentTankInspections). From those I write back to SharePoint Lists using Patch, only if there is a Connection.

InspectionGallery 

Items:

SortByColumns(
    If(!IsEmpty(CurrentTankInspections),Filter(
        CurrentTankInspections,
        TankID.Value = TanksGallery.Selected.'Bar Code (Tank ID)'
    )),
    "Created",
    Descending
)

Form "frmTankInspection" DataSource: 

CurrentTankInspections

Items

InspectionGallery.Selected