Answered

Delete row in repeating table on submit

(0) Share

Report

Posted on by ACPBSCi

222

Here's one for you. I have an app that's part form and part repeating table. Table works like a champ. Using the Reset feature to clear my forms works like a champ. However, the data that I enter into the fields of my repeating table does not clear:

I can do a lot of coding to clear those fields, but will that take away the rows, too? The code in the X for each row is:

RemoveIf(UserCollection,UserItemNumber=ThisItem.UserItemNumber)

So if I want all the rows to go away when I click "Save", I would need to

keep a count of all the rows that were added,
write a formula that removes the same number of rows

What would that formula look like? And how would I count the rows?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

GarethPrisk 2,828 on at

Like
a
(1)

Report
Copy link

Link copied!

RemoveIf can match and remove multiple rows, if the filter criteria works.
To clear the whole collection (all rows), use the Clear function Clear(UserCollection);
To count the rows beforehand, just CountRows(UserCollection) as a separate function before clearing.

Was this reply helpful? Yes No
ACPBSCi 222 on at

Like
a
(1)

Report
Copy link

Link copied!

Clear(Collection) worked! That's good to know. I was afraid having a repeating table would make it so complicated. I was definitely overthinking it. Thank you so much @GarethPrisk!!! That was the last hurdle on the first app I've ever built.

Was this reply helpful? Yes No