Missing value in the Gallery label

(0) Share

Report

Posted on by sreeponn

Hi all,

In my powerapp built on dataverse, I have a gallery which is filtered and sorted as below.

SortByColumns(galMyRequests.Selected.'000_PRApprovals',"crf1e_id")

In the gallery I have a label as follows

ThisItem.Approver.MemberEmail

Label value of member email disppears as soon as I change the gallery filter as follows, while other attributes from the table is fine

SortByColumns(
 Filter(galMyRequests.Selected.'000_PRApprovals', isMarkedDeleted = 'isMarkedDeleted (000_PRApprovals)'.No) 
 ,"crf1e_id")

Any idea why this happens? You reply will be much appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Sort by

Mira Ghaly 11,415 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @sreeponn

I am trying to replicate the same , for some reason when I use this directly like below, it doesn't work at all

Sort( Filter( VisitsGal.Selected.Approvers, 'Is Delered' = 'Is Delered (Approvers)'.No ), Name )

What I did to make it work, is on the select of the parent gallery , I created a collection and used it instead to do the filtration and I am using sort columns:

Sort( Filter( approvelsCol, 'Is Delered' = 'Is Delered (Approvers)'.No ), Name )

I think @WarrenBelz can shed more light here as I do not have a proper explanation why it is working on the collection but not directly.

Was this reply helpful? Yes No
WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the tag @Mira_Ghaly ,

Unfortunately, I am not a Dataverse user (SharePoint only)

Was this reply helpful? Yes No
sreeponn 25 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the response and try. Can you add lookup collumn table values in clearcollect? Can you please share your code?

Was this reply helpful? Yes No
Mira Ghaly 11,415 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@sreeponn

Is approval email a lookup? If you can explain your table structure it will be easier for me to replicate, so please explain your table structure as well as what you want to achieve.

Was this reply helpful? Yes No
sreeponn 25 on at

Like
a
(0)

Report
Copy link

Link copied!

Teammember has many Purchase requests and Approvals
Purchase requests has many Approvals

When a Purchase request is selected, gallary should show related approvals and approvers(team members). query breaks (or fails to display the email, there are no error messages) at the second level when additional filters are added.

Was this reply helpful? Yes No
Mira Ghaly 11,415 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@sreeponn

Is approver lookup from team member?

Was this reply helpful? Yes No
sreeponn 25 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes

Was this reply helpful? Yes No
Verified answer

Mira Ghaly 11,415 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@sreeponn

I have replicated again with your same Data Structure and it is working

Please try these few things as well:

1. Refresh your DataSources

2. Make sure the IsDeleted is set on the table and does not equal blank , try to set the field to yes and back to no and make sure it is saving.

Was this reply helpful? Yes No
sreeponn 25 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Mira once again for the taking time on this. In the end it still does not work for me, I think this is a delegation issue. This app had multiple screens and connects to multiple data sources. I made a mini version just connecting to three sources and it seems fine. Thanks for your support

Was this reply helpful? Yes No