Unanswered

Filter Gallery on a Lookup value - circular reference.

(0) Share

Report

Posted on by wrightcomply

I have a Canvas app that is where I want it with a gallery and a form. It's all based on a SharePoint list with many columns and a Lookup for Business Area that has 267 rows.

As the attachment depicts, I've been unsuccessful at filtering the gallery on the organization Business Area Lookup below because I get circular reference errors.

My Dropdown looks like this:

('... Organization', Title)

Note: using ... in place of the real organization name to keep confidential

Search(
[@'Information Map Attestation'], SearchInput1.Text, "Title", "Title"
)) && ([@'... Organization'],Title.Value = BusAreaFilter.Selected.Value || BusAreaFilter.Selected.Value = Blank() )
)

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

BCLS776 8,994 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Title.Value in your Search() statement does not sound like a column name in your list. Have you tried just Title?

Hope that helps,

Bryan

Was this reply helpful? Yes No
wrightcomply 44 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you, Bryan for your reply. The search function I showed was one of many ideas I've tried.

Here's what I need to do:

1. I need to filter on Business Area column on my sharepoint list. The Business Area column is a Lookup column because it has over 50 items. I'm learning that PowerApps doesn't play will with SharePoint lookup columns and haven't found a solution where someone has been successful with the delegation issue with them.
2. Here is what I've tried in the filter function but get errors:

Filter(
'Meijer Organization',
Title.Value = busAreaFilter.Selected.Value)
)

What I get is a circular error on this function. The Meijer Organization is the Lookup table. the busAreaFilter is the filter dropdown box on my PowerApp.

Does this help clarify any better? My attachments hopefully show what I'm trying to do and where the placement of the busAreaFilter is located in relation to a search box (Search([@'Information Map Attestation'], SearchInput1.Text, "Title", "Title"). The title here is pointing to the main (base) SharePoint List.

I'm wondering if the two titles are bouncing against each other?

Was this reply helpful? Yes No
BCLS776 8,994 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Yes, I avoid using the built-in Title column in a SharePoint List with a Power App. In fact, I usually turn off its "required" status and ignore it.

As you've discovered, lookup columns in a SharePoint list interfere with delegation and make interacting with the list several degrees more difficult. Instead, I'll put in a column that contains the ID of a record from another list I might want to lookup and do simpler lookups in the app (which are often then delegable).

Similarly, with Choice fields, I'll just use a single line of text column to store the choice label and make sure the app handles the label text properly.

Bryan

Was this reply helpful? Yes No
wrightcomply 44 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Bryan.

Was this reply helpful? Yes No