In working a collection/gallery, I need to be able to set a variable if an item is deleted but the collection still has a blank row. (InfoPath style repeating table)
Scenario: Warning is displayed if there is a blank row before the user can move to the next screen. This is to prevent blank rows from being patched to SharePoint.
When a record, populated or the blank row, is removed from the collection (Remove.ThisItem), the collection needs to be evaluated to determine if there is still a blank row and set the variable accordingly. This way if a populated record has been removed the blank row warning is still visible, but if the blank row has been deleted, then the warning is no longer visible.
I have tried all of these and none evaluate correctly. All set the variable to 'false' regardless if there is an empty row in the collection.
If(Markets, (!IsBlank(Region), Set(varBlankRow, false)
If(!IsBlank(Markets.Region), Set(varBlankRow, false)
If(!IsBlank(Last(Markets.Region)), Set(varBlankRow, false))
Solved! Go to Solution.
Please see the screenshot below. Formula for the button is below. It sets a warning notification and sets the global variable.
Please see the screenshot below. Formula for the button is below. It sets a warning notification and sets the global variable.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
182 | |
52 | |
41 | |
36 | |
29 |
User | Count |
---|---|
242 | |
82 | |
71 | |
69 | |
66 |