cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Getting Error on DataSource - Did not find any data

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.

 

APES Faster Payment.JPGDatasource 2.JPGDatasource.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
WarrenBelz
Super User
Super User

Hi @Jaleelford_123 ,

The error is in the Issue message

WarrenBelz_0-1653337552077.png

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

View solution in original post

3 REPLIES 3
WarrenBelz
Super User
Super User

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

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.

 

DataSource error.JPGVoid SP.JPG

WarrenBelz
Super User
Super User

Hi @Jaleelford_123 ,

The error is in the Issue message

WarrenBelz_0-1653337552077.png

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

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
Users online (5,375)