cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
arosario
Frequent Visitor

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

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.

2 REPLIES 2
v-yutliu-msft
Community Support
Community Support

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,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

Helpful resources

Announcements
Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

<
Users online (2,611)