Unanswered

AI Builder: remove special characters

(0) Share

Report

Posted on by Sane

I have an AI builder which extracts the information and stores it to an EXCEL sheet. Extracted column values must not have any special characters.

I get the above list of Prices after extraction, but how do I get rid of the 'comma'.

I understand that this must be handled during the below action, but I'm not able to write an replace expression for PRICE. In expressions, I cannot choose the PRICE value as the PRICE does not come up under dynamic content(Because its a line item.?). Would appreciate members help, or suggest another approach.?

Unable to locate PRICE here

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Gopala_Krishna 1,495 on at

Like (1)

Report

@Sane
In Power Automate you can double click on the Power Automate dynamic output and do ctrl + c to copy the expression behind the dynamic output.

You can then apply replace around this to achieve the desired output, when you do ctrl+c after selecting dynamic output it will copy the expression that you see when you hover the mouse over the dynamic output.

If the information shared helps you please consider giving a thumbs up and mark solution as resolved

Please follow my website PowerCards for more information related to Power Platform

Was this reply helpful? Yes No
Sane 10 on at

Like (0)

Report

Thanks for responding.
Tried this, but it throws the error invalid expression.Below is the code in expression
replace(@{items('Apply_to_each')?['BARCODE/value']},' ','')

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (1)

Report
Hi @Sane ,

@Gopala_Krishna is right, if it works please consider marking his solution:

Please select 'Expression'

and input:

replace(items('Apply_to_each')?['BARCODE/value'],',','')

Best Regards,

Bof

Was this reply helpful? Yes No
Sane 10 on at

Like (0)

Report

Thank you. Perfect solution !!!

Was this reply helpful? Yes No