Unanswered

Extracting Contract Details - Format Text Format to "Proper"

(0) Share

Report

Posted on 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

I have the same question (0)

All responses (2)

Answers (0)

JoeF-MSFT on at

Like (1)

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

Was this reply helpful? Yes No
VeeLearnMSFT 508 on at

Like (1)

Report

@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.

Was this reply helpful? Yes No