Unable to connect nested/sub-gallery from two SharePoint List

(0) Share

Report

Posted on by Bunly11

367

Hi all -

I am trying to created a nested gallery from two SharePoint list using common column "DrugName".

My second table uses a Lookup column from the parent table.

I have watched several YouTube videos but have not been successful connecting the two. I tried

But I get this error

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Bunly11 :

As the issue shows,this rule creates a circular referecne.

Once any controls uses it's own output to affect it's own data source,it will trigger a circular reference.

I’m not sure why you want to reference ‘Gallery1.Selected.DrugName’ from outside, usually I apply “ThisItem.DrugName” from inside.For emxample:

Filter(YourDataSource,DrugName=ThisItem.DrugName)

If you insist on using Gallery1.Selected.DrugName, then you need to use variables:

1\Add an arrow icon into Gallery1 and set it's items property to:

Set(TheVar,Gallery1.Selected.DrugName) /*TheVar is my custom variable*/

2\Set Gallery6's items property to

Filter(YourDataSource,DrugName=TheVar)

Best Regards,

Bof

Was this reply helpful? Yes No
Bunly11 367 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @v-bofeng-msft

I actually would be open to suggestions. I have been using gallery1.selected because that is what I learned watching Youtube videos and reading blogs. I have other galleries connected to Gallery1.Selected and do not know how to change.

I attempted to modify my code but get this error below. I use a searchbox so the user can select a drug and then they use the arrow icon to select the drug record.

With({TBL:DrugTBL},Search(Sort(Filter(TBL,DrugName=ThisItem.DrugName, PageNumber<=300),PageNumber,If(SortDescending1,Descending,Ascending)),SearchBox.Text,"DrugName"))

I also tried to use "TheVar" and I got this error in Gallery6
Any suggesstions on how to fix this?

Thanks you

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Bunly11 :

Could you tell me:

What is Gallery1's items property?

What propertyof the control is this formula in?

With({TBL:DrugTBL},Search(Sort(Filter(TBL,DrugName=ThisItem.DrugName, PageNumber<=300),PageNumber,If(SortDescending1,Descending,Ascending)),SearchBox.Text,"DrugName"))

Note: ThisItem.DrugName calls the value of the superior Gallery, so it can only be used in Gallery6

What is DrugTBL?

What is the data type of DrugName in QuickReference? It does not seem to be of text type.

Could you show more details?

Best Regards,

Bof

Was this reply helpful? Yes No