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
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,442)