web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Using Column formatting
Power Automate
Unanswered

Using Column formatting

(0) ShareShare
ReportReport
Posted on by

Hi everyone, I'm working on existing list having columns formating on a column.
This column formatting allow to have 2 icons each containing a link.

Here is my question. How can I recover the link of the 1st or 2nd icon of this column ? 

Please see the column formatting json code :

{
 "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
 "elmType": "div", 

 "children": [ 
 {
 "elmType": "a", 
 "attributes": { 
 "target": "_blank", 
 
 "href": "= (substring([$Documents], 0, if(indexOf([$Documents], '?csf') == -1, indexOf([$Documents] + '%§^$@*#', '%§^$@*#'), indexOf([$Documents], '?csf'))) + 'Exemple link/Exemple Link'", // Définit l'URL du lien en utilisant des fonctions de traitement de chaîne.
 
 "iconName": "ExcelDocument", 
 
 "class": "" 
 },
 
 "style": { 
 "cursor": "pointer", 
 
 "font-size": "250%", 
 
 "text-decoration": "none", 
 
 "color": "#107C41" 
 }
 },
 
 {
 "elmType": "a", 
 
 "attributes": { 
 "target": "_blank",
 
 "href": "= (substring([$Documents], 0, if(indexOf([$Documents], '?csf') == -1, indexOf([$Documents] + '%§^$@*#', '%§^$@*#'), indexOf([$Documents], '?csf'))) + 'Exemple link/Exemple Link'", 
 
 "iconName": "FolderQuery", 
 
 "class": "" 
 },
 
 "style": { 
 "cursor": "pointer",
 
 "font-size": "250%", 
 
 "text-decoration": "none", 
 
 "color": "#000000",
 
 "margin-left": "0.8em" 
 }
 }
 ]
}

ProtoSup_0-1692351133407.png

here is what it looks like ↑

 

I replaced my links by  "Exemple link/Exemple Link" but everything else is exactly the same.

If you have ideas or advices I'm ready to sent you lot of kudo ! 
Greatings 

Protosup'

Categories:
I have the same question (0)
  • SamLed Profile Picture
    2,340 Moderator on at

    Hi,

     

    There is no link to this icons, there is a reference:

    SamLed_1-1692357900801.png

    ______________________________________________________________

    If I have answered your question, please Accept the post as solution.
    If you like my response, please Thumbs Up.

     

  • ProtoSup Profile Picture
    on at

    Hi @SamLed , just after the "href" it's a link. How can I recover this link ? 

    Thanks

  • sandeepstw Profile Picture
    312 Moderator on at

    Hi There,

     

    The link is formed by using the expression specified in the 'href' attribute for the first "a" elmType. In your provided JSON- 

    '= (substring([$Documents], 0, if(indexOf([$Documents], '?csf') == -1, indexOf([$Documents] + '%§^$@*#', '%§^$@*#'), indexOf([$Documents], '?csf'))) + 'Exemple link'

     

    2nd item link should be same as first. To find  link programmatically. Parse the column formatting JSON. Navigate to the "children" property. For the 1st icon, retrieve the value of the "href" attribute under the first child. For the 2nd icon, retrieve the value of the "href" attribute under the second child.

     

    Please give kudos and mark as solution if it helps.  

      

    Thanks, 

    Sandeep Mishra 

  • ProtoSup Profile Picture
    on at

    Thank you @sandeepstw , you understand what I want to do, can you help me to write a formula or a power automate flow ? 
    Thanks in advance

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 247 Super User 2026 Season 2

#2
11manish Profile Picture

11manish 164 Super User 2026 Season 2

#3
trice602 Profile Picture

trice602 138 Super User 2026 Season 2

Last 30 days Overall leaderboard