User Profile
ganeshsanap
MVP
Joined 7 years ago
User Widgets
Recent Discussions
Re: Conditional Formatting in Sharepoint List based on expiry date within 30 days
Beastie1211 Not sure about all your requirements, but try this and see if it works for you: { "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json", "elmType": "div", "txtContent": "@currentField", "style": { "background-color": "=if(@currentField >= @now-604800000, 'green', if(@currentField > @now-1209600000 && @currentField <= @now-2592000000, 'amber', 'red'))", "color": "white" } } Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.Re: Adding a clickable button to A sharepoint list to update a Yes/No Field
eduarrdonuxus50 Yes, SharePoint JSON formatting supports internal name of columns hence you always have to use the internal name to get/update the column value. Reference: How to find the Internal name of columns in SharePoint Online? Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.Re: SharePoint: Microsoft Lists: New Lookup column type support
AnoRnymous This is the last update on this roadmap item: Reference: 100503 - SharePoint: Microsoft Lists - New Lookup column type support Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.Re: SPO library view
ash965 Did you try adding sorting based on Order column? Try following this Microsoft official documentation once and see if it works for you: Use sorting to modify a SharePoint list view Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.Re: Using the ID column to generate a number in a calculated column.
mvnair SuzanoSho Note: JSON formatted columns in SharePoint list ONLY shows/displays the value in column. It does NOT actually store the formatted value in column. So, you cannot use those formatted column values for sorting, filtering, etc. in list view OR cannot read those values in other applications like Power Automate, Power Apps, Using SharePoint REST APIs, etc. Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.Re: Comment in Microsoft List
Webguy06 Interesting use case! But unfortunately, I don't think you will be able to achieve your requirements using SharePoint Online / Microsoft Lists out of the box commenting feature. You will not be able to track who read the comments and who didn't (for individual user logins). Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.Re: Need to delete the coulmn in sharepoint
HarishM2155 Is this a SharePoint default list/library column or the custom column you have created? If you are using modern experience, you can try following this documentation as well: SharePoint - Delete a column in a list or library Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.Re: Send email to only interested colleagues when an attachment is added
Sung_GeonC If you are trying to run a flow using SharePoint JSON formatting as suggested by Priya, follow this Microsoft official documentation for steps to get Power automate flow ID: SharePoint JSON formatting - create a button to launch a Flow Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.Re: Completely remove the Modern page Banner/Title inside my communication site, similar to the modern p
olavasheim You can also check the rollout information on publicly available site as well at: Microsoft 365 roadmap ID 386904 Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
Groups
