Email + Submit form, When returning to Main Screen, Dont see the submitted item. But item exists in SP list.

(0) Share

Report

Posted on by wonka1234

920 Super User 2024 Season 1

I am trying to see my newly submitted item after i submit it in the edit form 1.

when it auto returns to the first screen i dont see the new item.

I've tried Refresh[datasource] on the OnVisible of browseScreen.

What else can i do here?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

BCBuizer 22,833 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @wonka1234 ,

Are you perhaps using a collection? In that case don't forget to collect the new item.

If not, please share the Items property of the gallery on the first screen.

Was this reply helpful? Yes No
wonka1234 920 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@BCBuizer no collection that i know of..

here is my items porperty of my browsegallery -

SortByColumns(
Filter(
[@'Data Source'],
If(Dropdown3.SelectedText.Value = "Filter for Requests", Status = "New Request" Or Status = "Assessment" Or Status = "Complete", Status = Dropdown3.SelectedText.Value)
And
StartsWith(
Control_two.Value,
'search box'.Text
)
),
"Title",
If(
SortDescending1,
SortOrder.Descending,
SortOrder.Ascending
)
)

Was this reply helpful? Yes No
BCBuizer 22,833 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @wonka1234 ,

Can you confirm [@'Data Source'] refers to your SP list?

I don't see anything obviously off in your formula, except for the use of the deprecated SelectedText property. Please use the Selected property instead and try again:

SortByColumns( Filter( [@'Data Source'], If( Dropdown3.Selected.Value = "Filter for Requests", Status = "New Request" Or Status = "Assessment" Or Status = "Complete", Status = Dropdown3.Selected.Value ) And StartsWith( Control_two.Value, 'search box'.Text ) ), "Title", If( SortDescending1, SortOrder.Descending, SortOrder.Ascending ) )

Was this reply helpful? Yes No
wonka1234 920 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@BCBuizer confirmed it points to SP list.

Tried your formula, still only two items showing in my brwosegallery... should be around 8.

Was this reply helpful? Yes No
Verified answer

LaurensM 12,516 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @wonka1234,

Please note that the Filter() is not delegable. Should your list exceed your data row limit (default 500 - max 2000) that could be the cause.

You could also try to reset your dropdown and search box in the OnVisible of that screen to remove any previous filters that were still active.

Reset(Dropdown3); Reset('search box')

As a final note, it may be beneficial to double check whether the newly created records contain all of the needed information to appear in that gallery. (e.g. correct Status column value)

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

Was this reply helpful? Yes No