How to: Get choice column options with SharePoint HTTP action in Power Automate

Sometimes you want to use SharePoint as a data source but want to enter the data elsewhere using Power Automate. In this case, if you have Choices columns you might need to get a list of the possible options to use inside your flow. You can do this using the SharePoint HTTP action.

In this example we use the options to update a form field in an Adaptive Card being sent in Teams, but you could use this data anywhere it makes sense within your own flows.

Nick DeCourcy

Nick DeCourcy is the owner and principal consultant at the Bright Ideas Agency. He has worked extensively in the education and non-profit sectors in areas including operations, facilities, and technology. He is passionate about getting technology implementation right, first time, by fully understanding how it impacts the employee and customer experience.

Previous
Previous

How to: Get your Microsoft 365 Tenant ID with Power Automate

Next
Next

Plan a potluck lunch with Teams and Adaptive Cards