web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Flow, replace data in ...

Power Automate

Unanswered

Flow, replace data in html table

(0) Share

Report

Report

Posted on by bertrandedin

49

Hello,

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

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":','')

it's a fail.

Someone of you have an idea ?

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

DamoBird365 8,942 Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No

Join the conversation