Canvas App – adding alternating colors to a gallery that’s sourced from a Dataverse table
Image Source: Shutterstock.com
Power Apps
Jul 29, 2023 10:00 PM

Canvas App – adding alternating colors to a gallery that’s sourced from a Dataverse table

by HubSite 365 about Alex Shlega [MVP]

Microsoft Power Platform Consultant/Solution Architect, Business Applications MVP

Citizen DeveloperPower AppsMicrosoft DataverseLearning Selection

The technique for adding alternating colors to a Canvas App gallery has been described in various posts,

The text discusses adding alternating colors to a gallery in a Canvas App that's sourced from a Dataverse table. It explains that this can be done by adding a new column to the data source which will store the sequential row number. This row number can then be used to calculate the fill color of the gallery row using the Mod function.

  • Add a new column to the data source to store sequential row numbers.
  • Calculation of fill color can be done using the Mod function.
  • Example given uses the “Demo Organizations” table.
  • Modification of the “Item” property of the gallery according to the provided screenshot.
  • Update the TemplateFill property to ensure it works correctly.
  • Patching the underlying data source could cause issues as it changes the data source.

Screenshots provided to illustrate the process offer the following guidance:

  • First screenshot demonstrates how to modify the "Item" property according to your requirements.
  • Updating the TemplateFill property is demonstrated in the second screenshot.
  • The potential complication of patching the underlying data source is shown in the last screenshot.

More on Adding Alternating Colors in Canvas App

This text provides a technique to enhance the visual appeal of a Canvas App gallery, giving it organizing structure. This technique involves using coding logic and the modification of properties within the app's data source. The use of the Mod function allow for systematic and patterned color application. The method involves specific steps and attention to patching the data to continue experience success in use.

 

 

Read the full article Canvas App – adding alternating colors to a gallery that’s sourced from a Dataverse table

Learn about Canvas App – adding alternating colors to a gallery that’s sourced from a Dataverse table

Canvas App is a way to add alternating colors to a gallery that’s sourced from a Dataverse table. To do this, a new column needs to be added to the data source to store the sequential row number. This number can then be used with the Mod function to calculate the fill color of the gallery row. For example, if there is a “Demo Organizations” table, the “Item” property of the gallery can be modified and the “TemplateFill” property can be updated to make it work. However, patching the underlying data source won’t be possible since it won’t be the same data source.

More links on about Canvas App – adding alternating colors to a gallery that’s sourced from a Dataverse table

Alternating dataverse row colors in a gallery
Dec 26, 2021 — Solved: Hello everyone, I have a canvas app that has a gallery connected to a table in dataverse. I would like to apply conditional ...
Alternate Row Color In Gallery PowerApps: Simplest Way
May 5, 2023 — “Alternate row color” is a user interface design style in which rows in a table or list are displayed with alternate background colors to make ...
Add Alternating Row Colours to Power Apps Gallery
May 20, 2021 — This article describes how to add alternating row colours to a Power Apps Gallery. Unlike using the ID to determine row colours this method ...
Alternate Row Color in Power Apps Gallery
Jul 13, 2023 — This Power Apps tutorial explains how to make alternate row color in Power Apps Gallery Control with various examples.
Power Apps: Alternate row Colors
Jul 27, 2021 — How to alternate row colors in Power Apps. Here's how to do it with filters, sorting, ... add more rows, and use that data in our galleries.
Gallery - How to conditionally set the row background color ...
Jul 6, 2023 — It's this feature that enables us to access row values and to set different background colours for specific rows.

Keywords

Canvas App, Power Apps, Dataverse Table, Mod Function, TemplateFill