"Friendly" date display format combine with custom json formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-217662%22%20slang%3D%22en-US%22%3E%22Friendly%22%20date%20display%20format%20combine%20with%20custom%20json%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-217662%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20a%20way%20to%20combine%20the%20great%20%22friendly%20date%20display%20format%22%20native%20to%20SharePoint%20Online%20with%20custom%20formatting%20of%20the%20date%20field%20using%20JSON%3F%20My%20goal%20is%20to%20color%20the%20date%20field%20red%20when%20it's%20prior%20to%20the%20current%20date%2C%20but%20I'd%20like%20it%20to%20use%20the%20friendly-type%20values.%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20252px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F38016i5C9BF077F2A98070%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22friendly%20date.PNG%22%20title%3D%22friendly%20date.PNG%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EChoosing%20%22friendly%22%20in%20the%20list%20settings%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20722px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F38017i6BBF6BD5B53C0561%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22custom%20format%202.PNG%22%20title%3D%22custom%20format%202.PNG%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3Evalue%20displaying%20like%20I'm%20hoping%20for%2C%20minus%20the%20color%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20723px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F38018i491CEFAEFD036EDF%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22custom%20format.PNG%22%20title%3D%22custom%20format.PNG%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3Eadding%20the%20json%20to%20add%20the%20color%20also%20negates%20the%20%22friendly%22%20date%20display%20format.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-217662%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1445710%22%20slang%3D%22en-US%22%3ERe%3A%20%22Friendly%22%20date%20display%20format%20combine%20with%20custom%20json%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1445710%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F33489%22%20target%3D%22_blank%22%3E%40Ian%20Bruckner%3C%2FA%3E%2C%20sorry%20to%20dig%20up%20an%20old%20post%2C%20but%20did%20you%20figure%20out%20a%20solution%3F%26nbsp%3B%20I'm%20trying%20to%20do%20the%20same%20thing%20here.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1445718%22%20slang%3D%22en-US%22%3ERe%3A%20%22Friendly%22%20date%20display%20format%20combine%20with%20custom%20json%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1445718%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F690461%22%20target%3D%22_blank%22%3E%40E_Mahn%3C%2FA%3E%26nbsp%3Bthere's%20no%20way%20yet%20to%20have%20friendly%20SharePoint%20dates%20with%20custom%20JSON%20formatting.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23333399%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Frequent Contributor

Is there a way to combine the great "friendly date display format" native to SharePoint Online with custom formatting of the date field using JSON? My goal is to color the date field red when it's prior to the current date, but I'd like it to use the friendly-type values.Choosing "friendly" in the list settingsChoosing "friendly" in the list settings

 

value displaying like I'm hoping for, minus the colorvalue displaying like I'm hoping for, minus the color

 

adding the json to add the color also negates the "friendly" date display format.adding the json to add the color also negates the "friendly" date display format.

 

2 Replies
Highlighted

@Ian Bruckner, sorry to dig up an old post, but did you figure out a solution?  I'm trying to do the same thing here.

Highlighted

@E_Mahn there's no way yet to have friendly SharePoint dates with custom JSON formatting.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User