Answered

Complex validation on a repeating section inside a Canvas App - how to highlight individual errors

Like (1) Share

Report

Posted on 21 Apr 2025 14:45:10 by CU21041441-0

I have a repeating section implemented as a gallery to collect rows of data from users.

Each row has fields like "Quantity", "Price", and "Date". I want to:

Highlight rows in red if any required field is blank
Prevent submission if any errors exist

How can I do row-level validation in a gallery?

Categories:

General Questions

All responses (2)

Answers (1)

Verified answer

vipuljain03 497 Super User 2025 Season 2 on 21 Apr 2025 at 20:07:52

Like (0)

Report
Complex validation on a repeating section inside a Canvas App - how to highlight individual errors

@CU21041441-0

You can implement row-level validation using ForAll, Collections, and conditional formatting.

1. Add a field to your collection to track row-level errors:

ForAll( colItems, Patch(colItems, ThisRecord, { HasError: IsBlank(Quantity) || IsBlank(Price) || IsBlank(Date) }) )

2. In your gallery template, add conditional formatting: Fill = If(ThisItem.HasError, Color.Red, Color.White)

3. Before submission, check:

If( CountIf(colItems, HasError) > 0, Notify("Please correct highlighted rows", NotificationType.Error), SubmitForm(Form1) )

You can even use icons to indicate error per row (Visible = ThisItem.HasError).

Check also:

https://www.youtube.com/watch?v=lJaMRnTsZlE

https://www.youtube.com/watch?v=dWMXomO3SNM

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

If this reply helped you, please mark this reply as suggested answer ✔️ and give it a like to help others in the community find the answer too!

Thanks,

Vipul
stampcoin 3,893 Super User 2025 Season 2 on 21 Apr 2025 at 15:56:38

Like (0)

Report
Complex validation on a repeating section inside a Canvas App - how to highlight individual errors

CU21041441-0 Hi,

some suggestion:

Use the collection for the gallery until it's validated then patch.

Use TemplateFill to tint rows red when Quantity, Price or Date is blank.

Disable the Submit button if has invalid rows.

Optionally add inline icons/messages per field for extra clarity.