I have written a Power App for a user to select multiple Purchase order numbers and then trigger a Flow. The Purchase order numbers are passed to the Flow as a JSON I have have then used the Replace function to create a string as follows.
PurchaseOrderNumber eq "PO510004" or PurchaseOrderNumber eq "PO510002"
I need to replace the double quotes with single quotes to be able to use the string as a filter in the D365 FinOps 'List items present in a table' action, but the Replace function doesn't allow this as the expression below results in 'The expression is invalid'.
Solved! Go to Solution.
There are a few different ways to do it, but here is an expression that will do it:
replace(outputs('Compose'), '"', decodeUriComponent('%27'))
change outputs('Compose') to whatever holds your filter string.
There are a few different ways to do it, but here is an expression that will do it:
replace(outputs('Compose'), '"', decodeUriComponent('%27'))
change outputs('Compose') to whatever holds your filter string.
That worked a treat, many thanks.
had the same issue but the above wouldn't work for me, I had to actually distinguish left/right sided quote marks for some reason.
in playing with a uri encoder i found this added info for each type of quote mark note the differences in parenthseis (left“ neutral" right”) results in this:
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
30 | |
29 | |
28 | |
20 | |
11 |