Skip to main content

Notifications

Power Apps - AI Builder
Answered

How converting data from form processor

(0) ShareShare
ReportReport
Posted on by 7

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:
  • Nevs_meeuw Profile Picture
    Nevs_meeuw 7 on at
    Re: How converting data from form processor

    @JoeF-MSFT Thanks this is working great!

  • Verified answer
    JoeF-MSFT Profile Picture
    JoeF-MSFT on at
    Re: How converting data from form processor

    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:

     

    JoeFMSFT_0-1650742901528.png

     

    2. Select the item as if it was a text line. Once selected copy it:

     

    JoeFMSFT_1-1650743029845.png

     

    3. Open the panel to write the expression, and start typing the expression: 

     

    JoeFMSFT_3-1650743191656.png

     

    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']

     

    JoeFMSFT_5-1650743269385.png

     

    Hope this helps! Let me know if its not clear. 

     

  • Nevs_meeuw Profile Picture
    Nevs_meeuw 7 on at
    Re: How converting data from form processor

    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?

  • JoeF-MSFT Profile Picture
    JoeF-MSFT on at
    Re: How converting data from form processor

    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. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,422

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,711

Leaderboard