Hello,
I have several models who are working well!
However to complete my power apps app, I need to convert some date from my form processor.
For example I have a column in my model who reeds a value 16.000. I need this to be 16000.
Also I have a date value from the model that is currently viewed as 14.04.2021 I need this to be 20210414.
I extract the information with a from processor and with Power Automate I create new items in a SharePoint list. Is there a clever solution to convert these columns? These are just two examples of many I have.
Hi @Nevs_meeuw - indeed, it seems table items don't appear under dynamic values when writing expression. Here's a workaround while we address this:
1. Add the value from the table directly into the action:
2. Select the item as if it was a text line. Once selected copy it:
3. Open the panel to write the expression, and start typing the expression:
4. Paste the item you copied in step #2. You will see that it will be copied something like: @{items('Apply_to_each')?['Unit/value']} , make sure you remove the @{} symbols. In my previous example, it should look like this: items('Apply_to_each')?['Unit/value']
Hope this helps! Let me know if its not clear.
Hi @JoeF-MSFT sorry for the late response. The values I want to change are processed from a table. When I select expression en choose replace, I can't select my dynamic value from the list to convert. Is this normal?
Hi @Nevs_meeuw - great to hear that you have a number of automations running with AI Builder? 🙂 May I ask for what use case? I'm always curious to learn how AI Builder is used.
To your question - you will need to use expressions in Power Automate to do those transformations. In the following sections in the AI Builder documentation you will see some common use cases:
I hope these example help illustrate what's possible. Let us know if you don't find a solution to a specific use case.