You’re offline. This is a read only version of the page.
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
Hi @Sane ,
@Gopala_Krishna is right, if it works please consider marking his solution:
Please select 'Expression'
and input:
Share
Report
All responses (
Answers (replace(items('Apply_to_each')?['BARCODE/value'],',','')
Best Regards,
Bof
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.
#1
Tomac
986
Moderator
#2
stampcoin
699
Super User 2025 Season 2
#3
Riyaz_riz11
577
Super User 2025 Season 2
