How to Retrieve Flat Values for Choice Fields in Power Automate flow with Multiple Lists?

(1) Share

Report

Posted on by CU10121005-0

Hi,

I’m building a flow that should export multiple CSV files from different SharePoint lists. I have a working flow, but for the columns with choice fields, I'm getting all the other details like `"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", "Id": x, "Value": "zzzz "`. I want to extract only the flat value from there. Normally, it is a single choice field; for a list, there might be one or two choice fields. All the others are text, number, or date.

NOTE: I created a reference list in SP that holds all my lists

ListName	ListURL	CSVFileName	CSVFilePath
test	https://sharepoint.com/sites/example	test.csv	/Shared Documents/CSVFiles
test1	https://sharepoint.com/sites/example	test1.csv	/Shared Documents/CSVFiles

my main flow

1. Trigger
2. Get items - connect to the configuration list
3. Apply to each - output of Get items
- Get items 1 - connect dynamically to the current list
- Create CSV table - output of Get items 1; columns: Automatic
- Create file - dynamic link to the path and CSV name; File content: Create CSV table output

e.g. CSV output

selected columns were choice columns

Thanks in advance for your help

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

trice602 16,164 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

You can use the following expression to capture the value only:

outputs('Get_Items_1')?['body']?['Value']

------------------------------------------------

⭐ If this was helpful, please like and mark as a verified answer to help others find this too!

Always glad to help! 💯💯💯💯💯

Tom

Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

Was this reply helpful? Yes No
trice602 16,164 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hey there!

I am following up on this post how to retrieve flat values for choice fields in power automate flow with multiple lists? in this category general discussion from 12/10/2024. I know the post is a little older, but it is a common question here so wanted to take a moment and follow-up. I see there have been 1 replies and 1 likes and asking if your question has been answered. If so, please help the community out by completing one or more of the following actions! Thanks in advance!

Easy as 1-2-3 ‼️💯⭐😎🆒🙏

1) Mark a reply as a verified answer - this is essential, and it helps others with the same general question find this thread. ✅

2) You can also mark one of more replies as a verified answer. Please take a moment and give the author credit for volunteering their time. ✌️

3) Like one or more replies. Kudos always greatly appreciated! 👍

Pro tip: if you found your own solution or workaround, feel free to add a reply to your own post and mark it as the solution too! The goal is to get this thread marked with a verified answer by anyone that finds one or more replies helpful!

Again, thanks in advance for reading and responding, always glad to help! Tom 💯💯💯💯💯

Was this reply helpful? Yes No
trice602 16,164 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

If I can help with anything else please let me know or tag me in a future post, I enjoy reading and answering questions. Always glad to help! Tom 💯💯💯💯💯

Was this reply helpful? Yes No