No Items to dsiplay

(0) Share

Report

Posted on by Canadiansal

310

I have a gallery and a Form next to each other.

They both have the same datasource, and the Items on the form is Gallery.Selected.

I have a button with Submitform.

When I run the App - the selected item shows up in the form, but when I click submit, the forms come back empty with "no items to display". I then have to select another item in the gallery. Is there a way to fix this - so that we don't have this message?

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

Gopala_Krishna 1,495 on at

Like
a
(0)

Report
Copy link

Link copied!

@Canadiansal

On the button where you have the submitform() add the function editform(formname) or you can do resetform(formname). Your complete formula will look like submitform(formname);editform(formname).

After the form is submitted the form gets reset due to which you see the message, once you setup the above formula you will not see the message after the form submit.

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

if the information shared helps you, please consider giving a thumbs up 👍 and mark solution as resolved
Canadiansal 310 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks - neither of these work. Could it be that I have to force a select in the Gallery somehow? Because when I select an item the error message goes away.
Some additional details.
The gallery items are filtered on a Week =0.
I use the Form to edit the records and change to Week = 1. So when I hit submit - that record with Week =0 does not exist anymore. So I will need the selected item in the gallery to move to the next item.
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Canadiansal

Change your Item property to Lookup(datasource,ID=Gallery.Selected.ID). I disagree with @Gopala_Krishna . You should almost never chain anything with SubmitForm(Form). Instead add any functions that you want to execute following form submission to the OnSuccess property of the form. You don't want to execute any functions if the form fails to submit! You could put ViewForm(Form1) in the OnSuccess property and the form to show that it was successfully submitted.
Canadiansal 310 on at

Like
a
(0)

Report
Copy link

Link copied!

Still coming up empty:
My gallery:
Sort(Filter(
'DB',
'Created By'.Email = "email@email.ca" && Week = "0"), ID,Descending)

The Form edits these records and changes the week to another value. So once submitted, the record will not be caught in the filter anymore. Is there some way to advance the selection to the next available record on success?