Extracting Contract Details - Format Text Format to "Proper"

Like (0) Share

Report

Posted on 11 Sep 2022 10:40:06 by VeeLearnMSFT

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:

AI Builder

All responses (2)

Answers (0)

VeeLearnMSFT 508 on 12 Sep 2022 at 10:33:30

Like (1)

Report

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 on 11 Sep 2022 at 20:18:47

Like (1)

Report
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!