Show no items in gallery

[NPatel12498]

I have a screen that has a gallery on it to add rows and fill out additional details. It is an editable grid. The gallery is connected to a SharePoint list, but I want it to appear blank when users land on that screen. Currently it lists out all of the items, however, I just want the new items to appear when Add row is clicked on.

Right now all items are visible, but I want the gallery to be blank when the user lands on this screen to be able to add new rows.

[rpersad]

Just thinking about the scenario what you can do is use a conditional statement to filter the gallery when the Add Row button is clicked.

So how the logic will work is when you click the Add Row button and a new gallery item is added, set a variable to true.

Set(newItem, true);

In the Item property of the gallery use an If statement to check if the variable newItem is true, filter where ID is blank else display entire gallery. Not sure if you would be able to check the ID but you can check if another required field is blank.

If(newItem,
Filter(collection, ID = Blank()),
collection
)

Of course once you click the Save button you would have to set the newItem variable to false.

[NPatel12498]

I have tried this approach. But, when I click add row, it doesn't show a new row at all. All the other items do disappear but there should be a new row added to allow the user to input data.

[rpersad]

What columns have you tried to filter the gallery by?

[NPatel12498]

The ID in the gallery is actually linked to the SharePoint list as Title.

[rpersad]

Are there any required fields in your list. If so you can try filtering using a required column, if not you may have to check all the columns for blank.

[NPatel12498]

This the only required field I have in the SharePoint list as of right now:

[rpersad]

Another approach could be is when u click on the add row button you submit the record with all blank values. 

Then u can get the ID of the last row, that you just submitted using the formula

Set(LastID, Last(Sort("Sharepoint List",ID,Ascending)).ID)

 Then filter out the collection by the value stored in LastID.

[NPatel12498]

Again, this code doesn't allow me to add rows and fill in the rows after hitting the add rows button.

This is the screen before I select Add row:

This is after I select add row: