Answered

Data from Microsoft List not showing on PowerApps

(0) Share

Report

Posted on by SH-23070720-0

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:

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:

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

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
SH-23070720-0 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
SH-23070720-0 on at

Like (0)

Report
Copy link

Link copied!

See below - TSA02700 is definitely in my list.

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
SH-23070720-0 on at

Like (0)

Report
Copy link

Link copied!
@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" ) )

Was this reply helpful? Yes No
SH-23070720-0 on at

Like (0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
Verified answer

Moreshwar 135 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
SH-23070720-0 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No