Answered

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)

Sort by

Verified answer

Gopala_Krishna 1,495 on at

Like
a
(1)

Report
Copy link

Link copied!

@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
a
(0)

Report
Copy link

Link copied!

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 Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
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
a
(0)

Report
Copy link

Link copied!

Thank you. Perfect solution !!!

Was this reply helpful? Yes No