Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Data from Microsoft List not showing on PowerApps

(0) ShareShare
ReportReport
Posted on by

Hello,

 

I have had a asset manager running smoothly using data from a Microsoft List. I have been importing assets from our current system into the Microsoft List so that I can fully test the Power App when all assets have been inserted.

 

I have come across a problem where all recent assets I have imported are not showing up in the app, but show fine in the Microsoft List. See below:

RECORD_aSSET.png

This is the asset record in Microsoft Lists. This database is connected to the app with no issues.

 

Here is when I try to search for TSA02700 on my app:

ASSET_IN_APP.png

My search function is fine because I can still search for assets that have been in my list since I started it. The app is updated on my device too.

Does anyone have any idea how I can fix this?

 

Thanks

 

  • Re: Data from Microsoft List not showing on PowerApps

    Okay so in the app settings it was set to 500.

    I do feel I will go over 2000 - not sure how to index or do any of the sort. Will see if there's anyone else with my new issue.

  • Verified answer
    Moreshwar Profile Picture
    Moreshwar 135 on at
    Re: Data from Microsoft List not showing on PowerApps

    Hello - Check the number of items in your list and your app settings. If number of items is more than 500 then above won't work, you will have to change the limit to maximum 2000. However, you will still face this issue after 2000 items, so you may want to index your list and remove StartsWith to instead "=" to give exact result as this is delegatable but StartsWith is not. 

  • Re: Data from Microsoft List not showing on PowerApps

    It is something to do with that code because when I put in

    SortByColumns(Filter([@'Asset Manager'], StartsWith(Title, TextSearchBox1.Text)), "Title", If(SortDescending1, Descending, Ascending))

    (which is the normal code when you integrate an app with a list) it works fine but I can't search for a room.

  • Re: Data from Microsoft List not showing on PowerApps

    @CNT,

    Sorry - not been active over the weekend.

    I have the formula set so I can search for both the asset tag and the name of the room so I can see what assets are available in a room.

     

    With({SourceItem:'Asset Manager'},
    Sort(
     If(
     IsBlank(TextSearchBox1.Text),
     SourceItem,
     Search(
     SourceItem,
     TextSearchBox1.Text,
     "Location",
     "Title"
     )
     ),
     "Title"
    )
    )
  • CNT Profile Picture
    CNT 10,919 on at
    Re: Data from Microsoft List not showing on PowerApps

    @HeronS98 Can you post the formula you have in the Items property of the gallery in the chat?

  • Re: Data from Microsoft List not showing on PowerApps

    See below - TSA02700 is definitely in my list.

    Hnet-image.gif

  • Re: Data from Microsoft List not showing on PowerApps

    Hi @CNT 

    I have refreshed the source and re-added it but this hasn't made a difference.

     

  • CNT Profile Picture
    CNT 10,919 on at
    Re: Data from Microsoft List not showing on PowerApps

    @HeronS98 Try refreshing the Data Source. If it still doesn't work, remove & re-add the Data source.

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

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard