cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate I
Advocate I

Nested gallery fields do not show content

Hi,

 

Something is not working anymore, as it did one week ago?

 

I have a nested gallery:

  1. Gallery with CDS source : filter on one CDS text field (TextItem1) based on a search text field (TextItem)
  2. Gallery, within the first Gallery, with Sharepoint library source: filter on text field (TextItem2) based on TextItem1.Text

 

Searchfield=TextItem

Gallery1 : DataSource=CDS entity, Filter CDS Entity on TextItem.Text

   TextItem1 = CDS text field   (Visible = false)

   Gallery2 : DataSource=SPO Library, Filter SPO Library on TextItem1.Text + Height base of Countrows(Gallery2)

     TextItem2 = Sharepoint Library text field

     SPOfields ..

Filtering of Gallery2 (SPO) is working fine, number of records in Countrows is correct

Problem: the fields of SPO in Gallery2 do not show content? (since 2 weeks?)

 

Strange: When I change the Filter function into a Seach function it is showing the contents !? (with delegation issue)

 

Does anybody know why?

 

Thank you,

Lex

The Netherlands

4 REPLIES 4
Highlighted
Community Support
Community Support

Re: Nested gallery fields do not show content

Would yo please share the proper formula under the Gallery2 items property?

Are you using " = " within the Filter () function?

 

Instead, switch the "  = " with the StartsWith() function within the filter, see if that would make any difference. 

StartsWith( TextItem1, TextItem2 )

or 

StartsWith(TextItem2,TextItem1 )

 

I suspect the issue here might be related to the field type definition. There might be spaces added with the TextItem1 field.

 

Regards,

Michael

 

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Advocate I
Advocate I

Re: Nested gallery fields do not show content

Hi Michael,

 

Thanks for your reply.

 

Items property in nested gallery is now: (because we are live)

If(Len(txtSDocSearchCode.Text)>0; Search('Pilot Plant Quality System'; txtSDocSearchCode.Text ; "PADocSearchKey"))

 

'Pilot Plant Quality System' = SPO Library

"PADocSearchKey" = SPO text column 30 chars

txtSDocSearchCode = text label in PA in parent (next higher) gallery

 

Result: all items shown

 

Items property nested gallery is was:

If(Len(txtSDocSearchCode.Text)>0; Filter('Pilot Plant Quality System'; PADocSearchKey=txtSDocSearchCode.Text))

 

Result (tested again): no items shown

 

Note: that there are no spaces in het SPO FLOCsdocKey field. This is a 'normal' all character SAP asset code.

 

Now tested:

If(Len(txtSDocSearchCode.Text)>0; Filter('Pilot Plant Quality System'; StartsWith(PADocSearchKey;txtSDocSearchCode.Text)))

 

Result (tested again): no items shown

 

Working fine again when I put the 'search' line back again in items.

 

Highlighted
Advocate I
Advocate I

Re: Nested gallery fields do not show content

Did PA Staff look into this problem yet?  ... Hope you can help me solve this PA issue.

 

Problem for me is now that Search finds more files: e.g. "A4" gives result in "A4.14" and in "A4". Filter with '=' would only come with exact results. Locate will not help me either, because there are more files with the same search code. 

Highlighted
Advocate I
Advocate I

Re: Nested gallery fields do not show content

Michael, please see my replay post in the notification.

Helpful resources

Announcements
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (10,344)