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
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.
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.
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.
@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"
)
)
@HeronS98 Can you post the formula you have in the Items property of the gallery in the chat?
See below - TSA02700 is definitely in my list.
@HeronS98 Try refreshing the Data Source. If it still doesn't work, remove & re-add the Data source.