8
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.
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.
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.
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
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.
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
Share
Report
All responses (
Answers (
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
#1
WarrenBelz
146,702
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,015
Most Valuable Professional
