Getting Error on DataSource - Did not find any data

[Jaleelford_123]

Hello Team,

I have a Customized SharePoint, until yesterday the SharePoint was working fine. When I tried to check the SharePoint list. It is throwing an error. The error is on the SharePoint Form1 --> DataSource-- [@'Emergency TT Payment'] and Item property from the SharePointForm1 --> Item--> If(IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected),First([@'Emergency TT Payment']),SharePointIntegration.Selected), erro highlighted in Red. Also, in the DataSource, did not find any data. Ideally it will pull the list from ShareP0int. Not sure, what is the error, I have attached the screenshot for your reference. Pls help me out to fix the issue.

[WarrenBelz]

Hi @Jaleelford_123 ,

I am not sure why that is getting an error, but try this

With(
   {wID: SharePointIntegration.SelectedListItemID},
   If(
      wID > 0, 
	  LookUp(
         'Emergency TT Payment',
         ID = wID
      ),
      First('Emergency TT Payment')
   )
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

[Jaleelford_123]

Thanks Warren.

The issue here is on the DataSource, data not pulling from Sharepoint list. Where in on my other Void SharePoint item, the DataSource is pulling the data. Not sure, what is the issue in the Emergency TT SharePoint. Pls help me with the solution.

[WarrenBelz · Accepted solution]

Hi @Jaleelford_123 ,

The error is in the Issue message

The maximum is 12 lookup and person columns (combined). I mostly use none of either - this blog of mine on data structure may be of interest to you.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps