I'm trying to color some data in my data table.
So I have a sharepoint list with 3 data: Price, Name and billability called datagathering, in this list, I have some activities wich are billable and others aren't so if an activitiy is billable, I have a yes or else I have a no
So I add this list in a data table and I'd like to color the price where my activity is not billable
So first I tried to color the line where Activites is billable by this command: Color : If(DataGathering.Billable ="yes"; Black;Red) but here it doesn't work so any idea why?
And after that I'd like to only color the price and not the other rows in my table, is there a way to do that?
Many thanks in advance
You don't have to use double quotes in your formula. Try this:
As for coloring only the price, I would suggest to use the Gallery control (not Data Table) to list the content. In gallery, you could assign the color only to the TextBox control that contains the "Price" value.
The color property is only available on the table control and not on a column control. @dinusc gave you a good tip to use a gallery control instead.
"Yes" could be correct when you use a "Single line of text" column. When using a column of type "Yes/No", I use true or false.
Hi, I am new to this board and to the powerapps. I might not be asking in the correct place. I think I have similar issue. I am trying to update sharepoint from powerapps. Depending on the status I choose in the powerapp form, the share point cell need to be updated with a certain color. How can I do that? What would be the update? I am using patch to update data. Can I update color as well? Thank you
With cell, do you mean in a SharePoint view?
If thatbis the case: What you need is column formatting in SharePoint: https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting
This will format individual cells directly in sharepoint. Is there a way to send a format from the powerapps to let sharepoint know which color particular cell should be.
that's a very good question. I thought there would be some kind of a field property for color that I can set. I guess I was wrong. Thank you, for your help.
Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.
Did you miss the call? Check out the Power Apps Community Call here.
We are excited to announce the Power Apps Super Users!
Check out our new profile badges recognizing authored solutions!