Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - General Discussion
Unanswered

Flow, replace data in html table

(0) ShareShare
ReportReport
Posted on by 49

Hello,

 

I have created a flow to send an email with data from a list sharepoint.

 

bertrandedin_0-1617655767861.png

 

I want the text inside the 4th column be "Oui" or "Non". 

Here  the text {"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":1,"Value"  appear before.

 

I would like to delete this text in my flow, but I dont know how do that.

 

I try to use the fonction Replace: 

 

replace(body('Créer_un_tableau_HTML'),'{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":','')

 

 

bertrandedin_1-1617656590008.png

 

it's a fail.

 

Someone of you have an idea ?

 

 

  • DamoBird365 Profile Picture
    8,942 Microsoft Employee on at
    Re: Flow, replace data in html table

    Hi @bertrandedin 

     

    How are you getting on?

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    Cheers,
    Damien


    P.S. take a look at my new blog here

  • DamoBird365 Profile Picture
    8,942 Microsoft Employee on at
    Re: Flow, replace data in html table

    Hi @bertrandedin 

     

    I'm assuming you are building the HTML table dynamically using fields from SharePoint?  What expression do you use for the Repris Moe column?  I would suggest that you simply add ?['Value'] to the end of this expression in the expression builder.

     

    If you hover your mouse over that dynamic value, you will see the expression, alternatively you can use the peek code feature and copy the expression from your existing action.

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    Cheers,
    Damien


    P.S. take a look at my new blog here

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1