cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SamWinter
Level: Power Up

get data from collection array

Hello

 

Im am trying to get my data from a collection into a vertical gallery (insert>gallery>vertical) the problem is that the data i get from my request starts with an array "result[]" so i cant just use my collection as datasource in a vertical gallery. How do i cut every company value out of this collection array and put them without result array into for example another collection 

 

bild11.pngbild22.png

 

 

{
  "result": [
    {
      "company": "ANONYMOUS_COMPANY"
    },
    {
      "company": "KundeA"
    },
    {
      "company": "Koch"
    },
    {
      "company": "ABC GmbH"
    },

ClearCollect(Sammlung2;Strmo_col2.Getcustumername("company";"mytoken"))

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
rikdekoning
Level: Powered On

Re: get data from collection array

You can use the First() function to get the first result from your Sammlung2 collection, which is the collection you want to use.

First(Sammlung2).result
2 REPLIES 2
rikdekoning
Level: Powered On

Re: get data from collection array

You can use the First() function to get the first result from your Sammlung2 collection, which is the collection you want to use.

First(Sammlung2).result
Super User
Super User

Re: get data from collection array

You can also use the Lookup function to get to records other than the first.  Take a look at the following article that discusses using nested tables and records.

http://powerappsguide.com/blog/post/data---how-to-access-nested-collectionstables



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 78 members 4,429 guests
Please welcome our newest community members: