web

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

News and Announcements icon

Power Platform CommunityForums Power Apps how to convert a table...

Power Apps

Answered

how to convert a table to a value list?

(0) Share

Report

Report

Posted on by pegasus_yl

17

Hello ,everyone.

If I have a table like this, how can I convert it to a value list? like [100,200,300,60,20] without creating a new variable?

I know ForAll(thetable,Collect(value_list,Quantity)) wokrs fine. But I want to do it withput creating or updating a variable.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @pegasus_yl ,

Please try this formula

ForAll(thetable,Quantity)

You can use the outputs in items property of gallery or dropdown.

Best Regards,

Wearsky

Was this reply helpful? Yes No

Join the conversation