My App is not updating when a new item is added in SharePoint List

(0) Share

Report

Posted on by LS579

134

Hi All,

I am having an issue with my app gallery. When I add a new item to the SharePoint List in SharePoint, the new item is not showing in my app gallery. I have tried simply refreshing the data source. I have even tried reentering the data source and the fields to see if that will help to refresh the app. Nothing has worked and I have tried looking up a solution to this problem with no luck. My code for my gallery (which is a weekly calendar) is below and nothing fancy:

I do get delegation warnings with this code, but so far it has shown everything that was currently in the list, so I'm hoping this is not an effect of the delegation issue and can be fixed.

Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (26)

Answers (1)

Rusk 1,369 Super User 2024 Season 1 on at

Like (0)

Report

Do you see the new item if you don't have the filter?

Was this reply helpful? Yes No
LS579 134 on at

Like (0)

Report

I have removed the filter and as far as I can tell (it is pulling in all ~2000 items) the new item is still not showing. As this is a calendar, the filter is necessary for the app to work correctly like a calendar would, so it wouldn't be an option as a solution.

Was this reply helpful? Yes No
Tolu_Victor 197 Super User 2024 Season 1 on at

Like (0)

Report
Hi
I assume you might be facing a delegation issue and operator issue, but try this out.

It first uses the With function to get the filter criteria (hopefully solving delegation)
Then use "&&" instead of "And" (solving the operator issue)
Modify as needed
With( { varNextDay: ThisItem.NextDay, varEndTimeValue: ThisItem.Value }, Filter( 'ATCNA Cincinnati On Call Calendar', 'Start Time' < varNextDay && 'End Time' >= varEndTimeValue ) )

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
LS579 134 on at

Like (0)

Report

Thank you for your response. This did not fix the issue. I still cannot see the new item I added.

Was this reply helpful? Yes No
jefmeyer 166 on at

Like (0)

Report

Can you try using the ID in the filter rather than the date to verify the record can be returned that way? From there verify the date filter values (ThisItem.NextDay and ThisItem.Value) are correct. Make sure the time formats are the same as well as time zone.

Was this reply helpful? Yes No
LS579 134 on at

Like (0)

Report

Because its a calendar, the date filter allows each day to only show the events that are happening on that day. I'm not sure how to use the ID in the filter and make that work compared to using the date filters.

Was this reply helpful? Yes No
jefmeyer 166 on at

Like (0)

Report

Something like the following, where the ID value is the value of the item you're not seeing currently. This is just a debugging test to verify that the item is available.

Filter(
'ATCNA Cincinnati On Call Calendar',
ID = 2022
)

Was this reply helpful? Yes No
LS579 134 on at

Like (0)

Report

My entry showed up when I used the ID filter. I tried a couple of other things involving building a new screen with a search filter and I think I have figured out that this is an issue with delegation. There are other entries that are not showing up in my calendar and when I look at the quantity of total entries, it goes over the 2000 that the Power Apps delegation will show. If there is a work around to this issue, I would love to know. As I said, I tried using the same data and creating a normal gallery with a search box and that showed a delegation warning as well and only showed the first 2000 items in my data, so that won't work.

Was this reply helpful? Yes No
jefmeyer 166 on at

Like (0)

Report

Sorry, looks like Dates are now delegable in filters. SharePoint - Connectors | Microsoft Learn

Makes sense. Please take a look at this video from Reza as a possible workaround. PowerApps filter gallery by Date Time column and delegation (Part 2) - YouTube

Was this reply helpful? Yes No
LS579 134 on at

Like (0)

Report

Unfortunately, the workaround in that video is not plausible for our data as I would have to go back and update all the records. I have been trying other workarounds like LastN('DataSource', 2000), hoping it would grab just the last 2000 sets of records, but even that doesn't work. Power Apps does not want to look past the 2000th record in my data no matter what I do. The next step may be to delete any earlier records, I could possibly handle that with a Power Automate flow, so that it is regularly deleting the records, but I'll have to do some more research on that.

Was this reply helpful? Yes No