web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Data Operation - Selec...

Power Automate

Answered

Data Operation - Select Map way to get the value of item

(0) Share

Report

Report

Posted on by Kimii

134

Hi,

I'm trying to create CSV table from Sharepoint list data and can not choose the value of [subject] column.

On the 1st graph,
the result of subject come back with an array instead Value and I don't know the method to write in Select map
Please help !!

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (2)

Sort by

Verified answer

Shujaath_Khan 1,111 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Kimii,
as you can see the subject is an array, in select action can you try something like below
subject = first(json(variables('testVar'))?['Subject'])?['Value']
The above expression extracts the first element from the array and then takes content from the Value key
Thanks
If this post helps, please consider Accepting it as the solution. Thumbs up if it helped you other way.

Was this reply helpful? Yes No
Verified answer

Kimii 134 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Shujaath_Khan
Following your suggest and I changed subject selected input to
first(item()?['Subject'])?['Value']
it gave the right result.

Many thanks to you !

Was this reply helpful? Yes No

Join the conversation