How to Get SharePoint Choice Values in Power Automate?

Do you know how to get SharePoint choice values in Power Automate? If not, then no need to worry.

This Power Automate tutorial will teach you how to get the SharePoint single-choice column value in Power Automate.

Also, I will show you how to get the SharePoint multi-select choice column value in Power Automate with various examples.

How to Get SharePoint Choice Values in Power Automate

Here, I will explain all the steps of two things. Such as:

  1. Power Automate get SharePoint single choice column value
  2. Power Automate get SharePoint multi-select choice column value

Let’s describe it one by one.

Get the SharePoint single-choice column value in Power Automate

Here, I will explain how we can get a single value of the SharePoint choice field with a simple scenario. To achieve it, follow the steps below.

Example:

I have a SharePoint Online list named “Task List” with a few columns and their data types.

ColumnsData Types
Task Name (renamed Title)Single line of text
Task DescriptionMultiple lines of text
Task Start DateDate and Time
Task End DateDate and Time
Task StatusChoice [Started, Completed, Pending]

This is what the SharePoint list with different columns looks like.

Power Automate get value of SharePoint choice field

1. Open the Power Automate home page, click on + Create-> Select Automate cloud flow -> Enter the flow name and choose the trigger’s flow (When an item is created or modified) -> Click on Create.

  • In this trigger, provide the details below:
    • Site Address: Enter SharePoint site address.
    • List name: Provide the SharePoint list name.
How to Get SharePoint Choice Values in Power Automate

2. Next add the ‘Initialize variable’ flow action to store the text value during the flow and set the required fields.

  • Name: Enter the name of the variable.
  • Type: Select the data type of variable as String -> Click on + New step.
Power Automate Get SharePoint Choice Values

3. Now add an action Append to string variable and provide the required field.

  • Name: Provide the variable name.
  • Value: Here, I have entered the value as Completed.
Get single value of SharePoint choice field in Power Automate

4. Then add the Compose flow action to perform complex operations or calculations, manipulate data, or store temporary values and set the detail.

  • Inputs: Here, I have given TaskStatus from the dynamic content.
How to get single value of SharePoint choice field in Power Automate

5. Now click on Save and then Test it Manually. Then, the compose flow action will display the output according to the inputs set in the compose flow action.

Get a single value of SharePoint choice field in Power Automate

This is how to get a single value of a SharePoint choice field using Power Automate.

Get the SharePoint multi-select choice column value in Power Automate

In this section, I will explain how to get multiple values of the SharePoint choice field in Power Automate.

Example:

I have taken a SharePoint list named ‘Internal Job Post’ with different columns and data types to achieve this.

ColumnsData Types
Job TitleSingle line of text
Job DescriptionMultiple lines of text
SkillsChoice
Job Post DateDate and Time

This is the image of a SharePoint list with different columns looks like.

Power Automate get value of multi choice field

As per the requirement, I want to get multiple values of the SharePoint choice field using Power Automate.

  1. Open the Power Automate home page, click +Create -> Enter the flow name and choose the trigger’s flow (Manually Trigger flow) -> Click Create.
    • Click on + Add an input -> Select Date (renamed as Post date) in this trigger.
How to get value of SharePoint choice field using Power Automate

2. Add a ‘Get items’ flow action to retrieve all the items from the SharePoint list and set the details.

  • Site Address: Provide the SharePoint site address.
  • List Name: Select the SharePoint list name.
Get multiple value of choice field using Power Automate

3. To store the text value during the flow add an ‘Initialize variable’ flow action and set the details.

  • Name: Provide the Initialize variable name.
  • Type: Select the data type of the variable as String.
Get SharePoint multi-select choice column values in Power Automate

4. Next, add an ‘Append to string variable’ to concatenate the names of items in a collection and set the required fields.

  • Name: Select the name of a variable.
  • Value: Enter the value of the string variable.
How to get SharePoint multi-select choice column values in Power Automate

5. Now add the ‘Create HTML table’ flow action for formatting and presenting data in a structured manner and set all the required fields as shown below

  • From: Select the value from Dynamic Content.
  • Columns: Select the Custom table from the drop-down.

Then, add the custom table value manually, as shown below.

HeaderValue
Job Title
Job Description
Skills
Select value from the dynamic content under Get items and expression.
Power Automate get multiple value of SharePoint choice field
join(xpath(xml(json(concat('{"body":{"value":', item()?['Skills'] , '}}'))), '/body/value/Value/text()'), ', ')

where @odata converts it into a valid JSON. Valid JSON can be converted into xml, and xpath will allow you to access the desired values from the array. Join will format the final output into a comma-separated string.

6. Now it’s time to Save and Test. Click on Save and Test it Manually. Then, you can see the output in the Body of the Create HTML table flow action.

Power Automate get SharePoint multi-select choice column values

This is how Power Automate gets multiple values of a SharePoint choice field.

Conclusion

I hope this Power Automate tutorial taught you how to get the SharePoint single-choice column value in Power Automate.

Also, we discussed how to get the SharePoint multi-select choice column value in Power Automate with various examples.

Additionally, you may like some more Power Automate tutorials: