Skip to main content

Notifications

Announcements

🌸 Community Spring Festival 2025 Challenge 🌸
Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps - Power Query / Data not showing corre...
Power Apps - Power Query
Suggested answer

Data not showing correctly in PowerApps gallery . SharePoint list to PowerApps not synced properly

(0) ShareShare
ReportReport
Posted on by MH-18090339-0 14
Data not showing correctly in PowerApps gallery . SharePoint list to PowerApps not synced properly .
 
Up to data showing 19/02/2025 but till date we have data in Sharepoint list. 
Categories:
General Comment
sharepointlist.png
Powerapp Gellary.png
  • WarrenBelz Profile Picture
    WarrenBelz 146,513 Most Valuable Professional on at
    Data not showing correctly in PowerApps gallery . SharePoint list to PowerApps not synced properly
    Please see my updated post
  • Suggested answer
    MS.Ragavendar Profile Picture
    MS.Ragavendar 1,126 on at
    Data not showing correctly in PowerApps gallery . SharePoint list to PowerApps not synced properly
    Hi,
     
    Implement a pagination gallery to achieve your requirement, I can recommend you to use tables but its still in preview we cant use that in production environment.
     
    Useful Links
     
     
    This will give you step by step instruction how to implement the functionality.
     
    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.
  • MH-18090339-0 Profile Picture
    MH-18090339-0 14 on at
    Data not showing correctly in PowerApps gallery . SharePoint list to PowerApps not synced properly
    it showing =305.. pls find attached screenshot sharepoint list : 628
    sp628.png
    305.png
  • MS.Ragavendar Profile Picture
    MS.Ragavendar 1,126 on at
    Data not showing correctly in PowerApps gallery . SharePoint list to PowerApps not synced properly
    Hi,
     
    There is no restriction, by default based on the limit between (500-2000) data will load by using pagination you can extend the data. 
     
    There is also Modern Table control can you use that and check how much data its showing.
     
    Also can you add label and countrows(filter query) what is the total data which is being returning?
  • WarrenBelz Profile Picture
    WarrenBelz 146,513 Most Valuable Professional on at
    Data not showing correctly in PowerApps gallery . SharePoint list to PowerApps not synced properly
    The filter is not Delegable, so as you have more than 500 items in your list, you will not receive the full results. Maybe try this 
    With(
   {
      _Data:
      Sort(
         Filter(
            'PRODUCTION - REPORT',
            'monthno.' = Month(Today())
         ),
         ID,
         SortOrder.Descending
      )
   },
   Filter(
      _Data,
      Or(
         TextInput2.Text in 'Shift Engineer Name'.Value,
         TextInput2.Text in 'Machine Name'.Value,
         TextInput2.Text in 'Operator Names'.Value
      )
   )
)
     
    Please click Does this answer your question 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 a Like.
    MVP (Business Applications)    Visit my blog Practical Power Apps    LinkedIn    Buy me a coffee
  • MH-18090339-0 Profile Picture
    MH-18090339-0 14 on at
    Data not showing correctly in PowerApps gallery . SharePoint list to PowerApps not synced properly
    I Have did Re index  and remove data source , re connected same issue. it will show only 305 line items. Any restriction is there?? 
  • WarrenBelz Profile Picture
    WarrenBelz 146,513 Most Valuable Professional on at
    Data not showing correctly in PowerApps gallery . SharePoint list to PowerApps not synced properly
    Firstly get rid of the text filter in the date (although I do not think this is the issue) - although you will not get an error, this does not really work. 
    Filter(
   'PRODUCTION - REPORT',
   'monthno.' = Month(Today()),
   Or(
      TextInput2.Text in 'Shift Engineer Name'.Value,
      TextInput2.Text in 'Machine Name'.Value,
      TextInput2.Text in 'Operator Names'.Value
   )
)
    The reason I asked for the Items was to confirm it was directly filtering the data source, which it is. The next thing to do is to reindex your SharePoint list (List Settings > Advanced Settings > Reindex list ). You also have not confirmed whether this happens when you first open the app (or does not not refresh after an update)
  • Suggested answer
    MS.Ragavendar Profile Picture
    MS.Ragavendar 1,126 on at
    Data not showing correctly in PowerApps gallery . SharePoint list to PowerApps not synced properly
     
    1. Can you try remove the datasource and trying adding once?
    2. Did u tried refresh the datasource in the powerapps?
    Please try this once and revert back.
  • MH-18090339-0 Profile Picture
    MH-18090339-0 14 on at
    Data not showing correctly in PowerApps gallery . SharePoint list to PowerApps not synced properly
    Yes connected Correct Data Source.
     
    PLs find attached photo 
    DAT source.png
  • MH-18090339-0 Profile Picture
    MH-18090339-0 14 on at
    Data not showing correctly in PowerApps gallery . SharePoint list to PowerApps not synced properly
    Yes It was working  but yestreday onwards , it showing  data not properly . I have not made any changes. 
     
     
    Gallery Item: 
    Filter('PRODUCTION - REPORT','monthno.' =Month(Today()),
     
    Or(TextInput2.Text in 'Shift Engineer Name'.Value,TextInput2.Text in Date,TextInput2.Text in Date,TextInput2.Text in 'Machine Name'.Value,TextInput2.Text in 'Operator Names'.Value))

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

🌸 Community Spring Festival 2025 Challenge 🌸
Welcome to the Power Platform Communities

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,513 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,683 Most Valuable Professional

Leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans