Microsoft Power Automate to "Empty" an AudioFile field

Open up the 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. page.

Go to the Dialogue Management, IVR list.

Click on the List and then List Settings in the top ribbon.

In the Columns section locate the item for the Audio option we need to adjust ‘Audio Question’.

In the Edit Column view under the Relationship Section uncheck the Box for ‘Enforce relationship behavior’.

Click OK to Save.

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 the Audio Question from an IVR Choice

• Starting:

  1/1/2023 at 07:00 PM

• Repeat every:

  1 day

Click “Create”

• The following window shows-up

  

If you re-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. Beware this Power Automate time is in UTC.

• If your UCC runs in a different time zone, compared to the time zone that you (your browser) are in, please update the start time accordingly (optionally you can set the time zone of the UCC SharePoint Site).

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, for example, by typing “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 “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 AudioQuestion Id Value and enter the value of -1 and then chose the option for ‘Use ‘-1’ as a custom value’.

The field could look like below (but "-1" wrapped in an Expression is also possible):

Finally click “Save”

• In the top

  

• Or the bottom