I created a powerapp from an existing sharepoint list. The record list displays all existing records but the new records added through the powerapp does not shows in a Browser screen. The record get saved in the Sharepoint list. Refresh button works for updates fine. I can see updated records, but not new.
If I create new powerapp from the same sharepoint list (with new records), all records shows in Browser screen.
I've had a similar issue like this before. Do the new records show up once you have left the browse screen and come back?
Hum...I'm sorry that is happening! What you could possibly try, just to rule out some possibilities and help narrow down the problem could be creating a new app with a gallery pointing at the same list and a form that creates new items etc. to see if that works or still doesn't work. Hopefully that can help bring some answers and narrow it down perhaps.
Let me know if that helps at all or not!
Hi @JuliaM ,
Filter syntax is
Filter( Table, Formula1 [, Formula2, ... ] )
Having said that "," will not work as it is not the right syntax.
I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.
Wanted to let anyone else having this problem know what I did; it is the filter function causing a problem. I created 2 galleries with one's formula for Items as the following:
SortByColumns( Search( [@'[dbo].[Support_Contacts]'], TextSearchBox1.Text, "Site_Name", "Service_Type", "Service_Provider", "Contact_Name" ), "Contact_Type", If( SortDescending1, Descending, Ascending ) )
However, this search function does not work for me because I am looking at splitting all phrases in my search box to search across multiple columns; like a google query.
But doing this formula above, I can see my newly added records (that I can see on my backend side).
My problem is that I couldn't see it with this formula that I use for search on split keywords across multiple columns:
SortByColumns( Filter( '[dbo].[Support_Contacts]', Find( "0", Concat( Filter( Split( TextSearchBox1.Text, " "//or any delimiter. ), !IsBlank(Result) ), If( TrimEnds(Result) in Contact_Name || TrimEnds(Result) in Site_Name || TrimEnds(Result) in Business_Unit || TrimEnds(Result) in Service_Type || TrimEnds(Result) in Contact_Type || TrimEnds(Result) in Service_Provider || TrimEnds(Result) in Contact_Email || TrimEnds(Result) in Contact_Phone,// etc. "1", "0" ) ) ) ), "Contact_Type", If( SortDescending1, Descending, Ascending ) )
And then I read up on delegation with large (over 500 items, which is the case in my situation).
For me, I don't expect my data source to be over 2000 records, but it is > 500.
Changing the setting to 2000 (the max) worked for me; and I could keep my 2nd formula. It's messy, but shows the limitations of this platform.
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!