Next Gen Data Learning – Amplify Your Skills

Blog Home

Blog

Power Automate Connectors: Number, Text, And Date Time

by | Power BI

Power Automate offers a variety of connectors that we can use to create workflows. In this tutorial, we’ll familiarize ourselves with some built-in Power Automate Connectors that transform strings into another format. We’ll talk about Number Functions, Text Functions, and Date Time

Power Automate connectors

Using these Built-in connectors is quite easy. Just click the arrow bar to see all the available Built-in connectors.

Power Automate connectors

Power Automate Connectors: Text Functions 

Let’s click the Text Functions connector.

Power Automate connectors

We’ll then see that there are two available actions – the Find text position and the Substring action. 

Power Automate connectors

We can click the icon alongside the action to see the description pertaining to that specific action.

Power Automate connectors

Power Automate Connectors: Number Functions 

We also have the Number Functions.

Power Automate connectors

The main action for this connector is the Format number that’s basically for formatting numbers using a format string.

Power Automate connectors

Power Automate Connectors: Text Functions

The Date Time connector is used to format date and time.

Power Automate connectors

This connector has 6 different actions: Add to time, Convert time zone, Current time, Get future time, Get past time, and Subtract from time.

Power Automate connectors

For example, let’s click the Convert time zone action.

Power Automate connectors

 We’ll then see the steps to easily format time zones.

Power Automate connectors

Using Transformative Power Automate Connectors In A Flow

Let’s now try to use the Text Functions connector. For this example, let’s create a flow where the user needs to enter an input.

Power Automate Connectors

After that, click Add an input.

Power Automate Connectors

These are the different types of user inputs that we can use on our trigger.

Power Automate Connectors

Click the Text option.

Power Automate Connectors

Then, the Input field will be displayed.

Power Automate Connectors

In the given set of built-in connectors, click the Text Functions.

Power Automate Connectors

Then click the Substring action.

Power Automate Connectors

For the Text field, choose the variable Input under the Dynamic content tab.

Power Automate Connectors

After that, type 0 into the Starting Position field and type in 10 at the Length field. This will allow us to get the first 10 characters of the input that the user types in.

Power Automate Connectors

Next, click the New step button.

Power Automate Connectors

Let’s search Slack in the Search field and click the Slack connector.

Power Automate Connectors

Choose the Post message action.

Power Automate Connectors

After that, choose random for the Channel Name field.

Power Automate Connectors

For the Message Text field, click the Dynamic content variable Substring.

Lastly, click Save.

Testing Transformative Power Automate Connectors In A Flow

Let’s now test our flow and see how it works.

Choose the I’ll perform the trigger action option. After that, click the Save & Test button.

Then click the Continue button.

Let’s type “UnitedStatesofAmerica”. After that, click the Run flow button.

Once the flow runs successfully, click Done.

Go to Slack and we’ll see that our input appeared with only 10 characters as specified.

Using The Substring Function

We also have the option to not use the Substring variable. Instead, we’ll use the substring function. Let’s try to do that by editing our current flow.

Remove the Substring variable.

Then, click the Expression tab. Search and choose the Substring function.

When clicked, we’ll see the Substring function keyword that’s already provided for us in the Function field.

Place the cursor in the middle of the parenthesis and click Dynamic content

We need to use the same input that the user enters. So, let’s choose the Input variable. 

After that, type in the starting point (0) and the length (10). Make sure to add a comma and a space right after each content.

This image has an empty alt attribute; its file name is oOW5QzmgeyKD52T_04BuwsCYTaLo-pC_rSNP2FLdzPCSX3JLtYDbSlYx2kE-w0mIt9RBmgFx3ryGQSxFMmGsDINM4WdFvPWLZt1u0yb_FZi-mdGi49scTXKLPnZcEgDRmpfQzqwJ=s0

Lastly, click OK.

Since we don’t need our Substring connector anymore, we can just delete it.

A dialogue box confirming the action will pop up. For that, just click OK.

Testing The Flow

Let’s now click Test.

Then click Save & Test.

Type in “UnitedStatesofAmerica” in the Input box field and click Run flow.

Lastly, click Done.

In our Slack, we’ll see that our input appeared similarly to our previous output even though we used the substring function instead of the Substring connector.

***** Related Links *****
Power Automate Actions | A Deep Dive Tutorial
Microsoft Flows: Editing And Tracking In Power Automate
Power Automate Expressions – An Introduction

Conclusion

There are lots of available Power Automate connectors that are designed for user-friendliness. You can definitely use them and they’re much easier to use in workflows. However, you can also simply use Expressions, which can do the exact same thing.

If your goal is to get certified as a Power Automate user, I highly recommend you to be equally familiar with both the built-in connectors and expressions.

All the best,

Henry

Related Posts