Formatting color and title

[Smittymitty95]

I have a custom app here with a filter that filters items based on a choice column listed as effective. I now want to filter Diesel price and gasoline price to the top of the list and change the color to yellow for the entire row to the right. How do I bring these two up to the front and color the row all the way to right with yellow. I have provided a screenshot and an example of this. 

[FLMike]

Hi @Smittymitty95 

Assuming this is a gallery correct? Are they stored in Dataverse of SharePoint? Is this a Collection of Data or the Table???

You have to have a column to sort on or you have to do it a goofy way. Let's pretend you want to Sort and put those 2 first, but you have NO numeric, dates, anything to do it by. Then you have to improvise

// New Collection

Collect(myOrderedResults, LookUp(DataSource, Title = "Gasoline"));
Collect(myOrderedResults, LookUp(DataSource, Title = "Diesel"));
Collect(myOrderedResults, Filter(DataSource, Title <> "Gasoline" And Title <> "Diesel"));

Now myOrderedResults has those 2 first

As for highlighting

Again assuming its a Gallery

In the TemplateFill Property

Switch(ThisItem.Title
    "Gasoline",
     Color.Yellow
    ,
    "Diesel",
    Color.Yellow
   ,
    Whatever Default Fill you want
);

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[Smittymitty95]

Hey Michael thanks for your response this is a blank vertical galley using the modern tools in SharePoint the data comes from a list in SharePoint. My goal is to have the same color scheme as the list and the same order of words as the list. For example, Gasoline and Diesel Grouped by yellow I have a drop-down canvas filter that filters these specific items to show. As you can see, they are all grouped by fuel location. And the divisions are grouped by blue. I just want to pull diesel and gasoline up make the rows yellow and the Divisions rows blue and keep them in order. 

[FLMike]

Hi @Smittymitty95 

Can you show me the list? Based on the order you had in the screen,. it didn't seem to match what you said, that's why I wrote it to put them first.

Is this list going to grow? Will records get replaced? etc

If for instance, Gasoline and Diesel are always first in the List and the others are in the order you want, then I would expect it to be like that in the picture.

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[Smittymitty95]

This is the list:

These are the columns in the list

The items in the list above and in the Power app are filtered by the effective column. The effective column is a yes/no choice column. The items shown are the ones listed as yes meaning currently effective. The rest are hidden in the app and in the list, this is the same for SharePoint. In power apps I used a dropdowncanvas to filter out the effective pieces of data.

The list is growing and is dynamically connected to this SharePoint site users – the use of the list is to show the most recent fuel prices and display them. In the order as it appears in the list, I am close. I just need to switch the Division 1-7 to be under Gasoline and Diesel and separated the column by colors. As the list shows. I want it to show yellow across for Gasoline and Diesel and Blue for the Divisions.

[Smittymitty95]

This maybe useful 

This is the coding for my gallery under the items panel

Item Properties for my Fuel Location

Also Effective

This default feature on my drop down canvas creates the filter for effective items.

[Smittymitty95]