Hi all
I have invoked successfully functions in Conditions Block, by clicking on advanced mode.
However, I haven't found the way to invoke such functions in Action Blocks. In my test flow, I included a Recurrence trigger, then GetRows (data source is an Excel File table in GoogleDrive), and finally OutLook Send Email.
So I tried with Body field from Outlook Send Email, and declared the following:
@replace(item()['Borrow--Date'], '2016-', '16-')
In the first iteration, for example, value store in the excel register is
"Borrow--Date": "2016-04-20T00:00:00Z",
so I was expecting the flow to send the following email body:
16-04-20T00:00:00Z
However, when I executed the flow, the above expression is literally inserted in the body, so the email body sent was
@replace(item()['Borrow--Date'], '2016-', '16-')
Thank you in advance!
No this cannot be done in the designer yet. What you are asking for is some sort of a toggle option on the input text box where a more advanced user can see the underlying 'function'. You should put this idea up in the Flow Ideas section.
Thank you for your feedback!
I found a potential solution in another thread: https://powerusers.microsoft.com/t5/Flow-Forum/Workflow-Variables-in-Microsoft-Flows/m-p/1711#U1711
So following @Anonymous recommendation, I tried "{@replace(item()['Borrow--Date'], '2016-', '16-')}" and it works!
Is this method design intent, I mean , is it officially supported?
BR
User | Count |
---|---|
23 | |
15 | |
14 | |
10 | |
9 |
User | Count |
---|---|
45 | |
29 | |
25 | |
24 | |
22 |