web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Filtering using button...

Power Apps

Answered

Filtering using button only retrieves that column

(0) Share

Report

Report

Posted on by Henryed07

129

I'm trying to filter a Dataverse table and store the information in a variable...it's only getting back that column and not the whole row

The following works in a Gallery:

Filter('Crew Recourses', 'Call Sign' = X1)

When i move the above to store in a collection it only retrieves the call sign information and not the other columns

ClearCollect(colDetails, Filter('Crew Recourses', 'Call Sign' = X1))

Any ideas?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

BideyYusuf 387 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @Henryed07 , ensure that you initiate the collection functions at onvisible of the Screen or On start, so that by the time you open the screen, the system has already filter the Datasource, and pass the records to the collection.
Put this ClearCollect(colDetails, Filter('Crew Recourses', 'Call Sign' = X1)) in the Onvisible property of the screen.

then On the Item property of the Gallery, put this colDetails.
it should give you the whole row filtered.

I hope this helps.
mark it as solution if it does. cheers.

Was this reply helpful? Yes No
Henryed07 129 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi.

I think you have miss read the issue.

It works fine in a gallery, i want the results in a collection not in a gallery. I want this to be stored in a collection, for some reason it's not working.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Henryed07,

Have you resolved your problem?

Do you want to show all the fields in a record based on the Filter() function?

Actually, the Filter() fucntion could get you a complete record including all the fiels, however you could use the ShowColumns() function to show any field from the data source.

ClearCollect(colDetails, ShowColumns(Filter('Crew Recourses', 'Call Sign' = X1),"Field1","Field2","Field3"))

Was this reply helpful? Yes No

Join the conversation