Unanswered

GalleryList Refresh not working

(0) Share

Report

Posted on by mattfiu

Hi. Thanks in advance for any help!

I have a gallery list and a display form on one screen and an edit form on a second screen. I cant get my gallery to update after a new record is added. I added a refresh(table1), my data source, to my submit button on the second screen. Ive also tried adding it to the the "OnVisible" field on my first screen but I cant get the Gallery to update.

Immediatly after I add the record, the gallery is accurate and the record in dropbox is accurate but when I restart the app the record is still in the dropbox excel sheet but not in the gallery. My gallery is set to:

If(TextInput1.Text="",Sort(Table1,Full_Name),Search(Table1,TextInput1.Text,"Full_Name"))

Manually refreshing the data source doesnt work either. I can edit fine but new records dont show up in gallery.

Thanks again,

Matt

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

v-yamao-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi mattfiu,

I create an app based on Excel table, and set the Gallery’s Item property with the function you mentioned.

When a new record is created, it will be updated on the gallery directly. I don’t need to refresh the data source.

Please also try if this code will work for you:
Gallery1.Items = Sort( If( IsBlank(TextSearchBox1.Text),
Assets,
Filter( Assets,
TextSearchBox1.Text in Text(ApproverEmail) ) ),
ApproverEmail,
If(SortDescending1, Descending, Ascending) )

Best regards,
Mabel Mao
mattfiu 37 on at

Like
a
(0)

Report
Copy link

Link copied!

My problem is that the gallery is correct UNTIL I refresh the datasource in any way. Then the gallery shows edits but not new records. Meaning even if i dont Refresh() the source, if I just close the app and open it again, the gallery is wrong but the spreadsheet is right. The Gallery only shows edits, not new records.

I will try your filtering method but the problem persists even when I just use Sort(Datasource,Column)

Thanks for the response!
Matt