Microsoft Power Automate to replace a field with "Empty" value

Navigate to Microsoft Power Automate.

Click “Create”

Below “Start from blank” select “Scheduled cloud flow”

Fill in a descriptive name for the flow, along with the date, time and recurrence. For example:

• Flow name:

  Remove a Skill from Welcome Message

• Starting:

  1/1/2023 at 08:00 AM

• Repeat every:

  1 day

Click “Create”

• The following window shows-up

  

If you open the “Recurrence” action by clicking on it, you can edit the recurrence.

• If you click “edit”, you will see that the current recurrence is set to 1 day (as set during the creation of the flow).

• When clicking “advanced”, you will see the start time of the flow. Please note this time is in UTC.

• If your UCC A Unified Contact Center, or UCC, is a queue of interactions (voice, email, IM, etc.) that are handled by Agents. Each UCC has its own settings, IVR menus and Agents. Agents can belong to one or several UCCs and can have multiple skills (competencies). A UCC can be visualized as a contact center “micro service”. Customers can utilize one UCC (e.g. a global helpdesk), a few UCC’s (e.g. for each department or regional office) or hundreds of UCC’s (e.g. for each bed at a hospital). They are interconnected and can all be managed from one central location. runs in a different time zone, compared to the time zone that you are in, please update the start time accordingly (optionally you can set the time zone of the UCC accordingly).

Next, add a new step to the flow by clicking “New Step”

• In this step, a variable will be added to the flow to represent an empty field.

In the search box, search for the Variable action by typing-in “variable”, and under “All” click the “variable” icon.

Next, in the Actions list choose ‘Initialize variable’

Next, provide a name of your choice (IE Empty Value), type of String and then click in the Value and make sure to select Expression and provide null then click OK.

After clicking OK it will look like this:

Next, add a new step to the flow by clicking “New Step”

• In this step, the Welcome Message will be retrieved from SharePoint.

In the search box, search for the SharePoint connecter by typing-in “SharePoint”, and under “All” click the “SharePoint” icon.

Next, search for the term “Get items” and select it.

After selecting this action, the connection towards SharePoint is tested. Once the connection is established successfully, the following form shows-up:

Fill in the Site Address of your UCC

• If the Site Address does not show-up in the suggestions, scroll to the bottom and select “Enter custom value” and type in the Site Address manually.

Next, select the List Name “IVRQuestions” from the dropdown

• Finally, click “Show advanced options”, and fill in the Filter Query.

  • To filter out the Welcome Message, the query should be:

    Title eq 'Welcome Message'

  • Other options can be ignored for now.

Again click “New Step” to add a subsequent action

• In this step, the Welcome Message will be updated.

In the search box, search for the SharePoint connecter by typing-in “SharePoint”, and under “All” click the “SharePoint” icon.

Next, search for the term “Update item” and select it.

Again fill in the Site Address and the List Name “IVRQuestions”

In the Id field select the Dynamic Content “ID” that is retrieved by the previous step “Get items”

As soon as you do this, Power Automate will automatically add a “Apply to each” block around the action “Update item”.

• This is because the “Get items” action could result in multiple items being retrieved from SharePoint. As such it will update each of the items accordingly.

  

• Click on “Update item” to expand the action, and continue with the final configuration.

In the Title field select the Dynamic Content “Title” that is retrieved by the previous step “Get items”

Click into the Action Value and select the ‘Enter custom value’ at the bottom. Now select your variable by the name you gave it in Step 2 (i.e. Empty Value).

The Final View will look like below:

Finally click “Save”

• In the top

  

• Or the bottom