Answered

How converting data from form processor

(0) Share

Report

Posted on by Nevs_meeuw

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.

Categories:

AI Builder

I have the same question (0)

All responses (4)

Answers (1)

JoeF-MSFT Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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:

Convert a form processing output string to a number in Power Automate: https://docs.microsoft.com/en-us/ai-builder/form-processing-model-in-flow#convert-a-form-processing-output-string-to-a-number-in-power-automate

Remove blank spaces in a form processing output in Power Automate: https://docs.microsoft.com/en-us/ai-builder/form-processing-model-in-flow#remove-blank-spaces-in-a-form-processing-output-in-power-automate

Convert a form processing output string to a date in Power Automate: https://docs.microsoft.com/en-us/ai-builder/form-processing-model-in-flow#convert-a-form-processing-output-string-to-a-date-in-power-automate

Remove currency symbols (€, $,…) in a form processing output in Power Automate: https://docs.microsoft.com/en-us/ai-builder/form-processing-model-in-flow#remove-currency-symbols---in-a-form-processing-output-in-power-automate

I hope these example help illustrate what's possible. Let us know if you don't find a solution to a specific use case.

Was this reply helpful? Yes No
Nevs_meeuw 7 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Verified answer

JoeF-MSFT Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Nevs_meeuw 7 on at

Like (0)

Report
Copy link

Link copied!

@JoeF-MSFT Thanks this is working great!

Was this reply helpful? Yes No