Unanswered

Show no items in gallery

(0) Share

Report

Posted on by NP-18101421-0

237

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (0)

NP-18101421-0 237 on at

Like (0)

Report
Copy link

Link copied!

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:

Was this reply helpful? Yes No
rpersad 776 on at

Like (0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
NP-18101421-0 237 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
rpersad 776 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
NP-18101421-0 237 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
rpersad 776 on at

Like (0)

Report
Copy link

Link copied!

What columns have you tried to filter the gallery by?

Was this reply helpful? Yes No
NP-18101421-0 237 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
rpersad 776 on at

Like (0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No