Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
Announcing Mentions and Quick Responses!
Give Back to the Community this Month
Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
Power Platform Community / Forums / Power Apps - Power Apps Pro Dev & ISV / Search function not sh...
Power Apps - Power Apps Pro Dev & ISV
Suggested answer

Search function not showing data for all users (powerapps modern version)

(1) ShareShare
ReportReport
Posted on by CU19090436-0 2
Hi, 
 
My search function in powerapps works perfectly and for the vast majority of users also however, very few are unable to see all the data from the database. When access was given, a group of users was created with equal access rights.
To solve it I have asked user to try the following: 
  • Use different browsers
  • Open link in another window rather than clicking web link
  • Clear cache
  • Refresh data in app
  • I have deleted/added gallery again and search formula and refreshed app
  • Removed filters from sharepoint list datasource
What else can i try please or could justify this behaviour?
BTW, no error message is displayed to the user, the list simply shows nothing but, when I search same key, I can see multiple records in it. Please advise and thank you
 
Categories:
Application Lifecycle Management (ALM)
  • Suggested answer
    Inogic Profile Picture
    Inogic 830 on at
    Search function not showing data for all users (powerapps modern version)
    Hi,
     
    It sounds like the issue might be related to how the search function is applied within your canvas app.

    Instead of search function, you can use filter function for Gallery. Here's a simple approach you can try:

    Here's an example formula for the "Items" property of the Gallery:
    Filter(DataSource,Lower(SerachTextBox.Text) in Lower(ColumnName))

    Let me know how it goes or if you need any further adjustments.

    Additionally, could you please share the Power Fx used in your current search function if possible? This will help us check it further.
     
    Hope this helps.
     
    Thanks!
    Inogic Professional Services: Power Platform/Dynamics 365 CRM
    An expert technical extension for your techno-functional business needs
    Drop an email at crm@inogic.com 
    Service: https://www.inogic.com/services/ 
    Tips and Tricks: https://www.inogic.com/blog/ 
  • Suggested answer
    FLMike Profile Picture
    FLMike 29,361 on at
    Search function not showing data for all users (powerapps modern version)
    Hi
     
    Here is what I would do just to give one more validation that in fact its a permission or other issue.
     
    1) Add a Button 
    2) in the onselect have it filter your datasource into a Collection, the same way that your gallery is filtered, literally use that filter
    3) In the Text of the Button, put in 
    Text(CountRows(YourGalleryItemFilter))
     
    And see how many rows it thinks it should be showing
    If its 0 then the user doesn't have the Proper Roles and or groups OR they are added to multiple groups and one group doesn't have permission and therefor blocks the Roles that give it permission.
     
    Please mark as answer if this solves your issue.
     
     

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

Welcome to the Power Platform Communities
Announcing Mentions and Quick Responses!
Give Back to the Community this Month
Join us in the Community for an AMA: December 12th Register Today

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

more Community News

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,297

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,890

Leaderboard

Featured topics

Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)

Product updates

Microsoft Power Platform Community release plans