Skip to main content

Notifications

Community site session details

Community site session details

Session Id : UM379IsKOQ6qt8EbcZzHOq
Power Automate - AI Builder
Unanswered

Extracting Contract Details - Format Text Format to "Proper"

Like (0) ShareShare
ReportReport
Posted on 11 Sep 2022 10:40:06 by 508

I have a process where upon uploading contracts to SharePoint it takes out key pieces of information and places them in a list. The text that is coming from the contract is not formatted the way I want it it to be.  Sometimes there are periods attached to the extract, sometimes there are brackets which I know I can fix using the replace dynamic function but is there a dynamic function that puts text in proper format.  Meaning if i extract "casual Employee"  Can I force the "c" in casual exmployee to be a capital "C" so that it states, Casual Employee.  This will look neater inside of the sharepoint list.  Microsoft excel has a function called proper which does this but not sure if Microsoft Flow does or not.  Thanks for the help gang.

Categories:
  • VeeLearnMSFT Profile Picture
    508 on 12 Sep 2022 at 10:33:30
    Re: Extracting Contract Details - Format Text Format to "Proper"

    @JoeF-MSFT Thank you, I would say my organization is impressed with this technology.  I have been trying to show them as much as I can. Still learning a lot. 

  • JoeF-MSFT Profile Picture
    on 11 Sep 2022 at 20:18:47
    Re: Extracting Contract Details - Format Text Format to "Proper"

    Hi @VeeLearnMSFT - good use case 🙂

     

    In Power Automate there is a function to put all the text in upper case: https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#toupper

     

    To only put the first letter of a field in upper case, you can use this expression that will do the transformation:

    concat(toUpper(slice(REPLACE-BY-AIBUILDER-VALUE, 0, 1)), slice(REPLACE-BY-AIBUILDER-VALUE, 1))

     

    Hope this helps!

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

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Automate - AI Builder

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 6 Super User 2025 Season 1

#2
CA-07040719-0 Profile Picture

CA-07040719-0 4

#2
BK-01100935-0 Profile Picture

BK-01100935-0 4

Overall leaderboard
Loading started