cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Super User
Super User

Re: Coloring gallery row using datacard value and a second criteria

@FelipeCaru 

So, in our last exercise, we added a Column called SortOrder...All good.

 

Now, you have Forms that have data sources set to your original source (and all its fields).  When you try to pass the Item to it, the item has an additional Field - the SortOrder.  It sees a mismatch with that and will give you this error.

So, one quick way around it is to Drop the Column.  However...DropColumns only works on tables, so we need to pull a little trick on it.  Here is what you want for your Item property:

   First(DropColumns(Table(BrowseGallery1.Selected); "SortOrder"))

 

This will first convert the Selected item in the Gallery to a table then apply the DropColumns to that table to get rid of the column, then return the First record (which there was only ever one anyway).

 

Hope this helps you to your next step.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.

View solution in original post

FelipeCaru
Level 8

Re: Coloring gallery row using datacard value and a second criteria

@RandyHayes 

That worked perfectly, thank you (:

Helpful resources

Announcements
New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (8,953)