cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
arosario
Level: Powered On

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
Community Support Team
Community Support Team

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

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.
arosario
Level: Powered On

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

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
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 476 members 6,610 guests
Please welcome our newest community members: