Answered

Circular reference error on a simple Search function

(2) Share

Report

Posted on by Jellman

Getting a "This rule creates a circular reference between properties error.." on a simple Search function where I am attempting to search a in the Items of a Gallery connected to a SP list:

Search(BadgeList,TextInput2.Text,"LastName")
 
I am following an example on Microsoft's on PowerApps site, but getting this error for some reason. Appreciate any assistance!

Categories:

Error handling

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Suggested answer

Michael E. Gernaey 53,963 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Jellman

Please add some details. Where did you exactly put this the wording is confusing

Please share a picture.

If you are inside the Gallery itself or self-references on a control within you will see this. Once I see the pictures and understand exactly where you put this code i can help you fix it.

Also, if you can explain what you are doing with the output

Was this reply helpful? Yes No
Jellman 8 on at

Like (0)

Report
Copy link

Link copied!

Added a pic.

Trying to output items in a list when typing in a text box. Very simple at this point.

Was this reply helpful? Yes No
Suggested answer

Michael E. Gernaey 53,963 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Jellman

Yeah, you cannot do that, because you would be constantly filtering on your own filter that's what causes this to be a circular reference.

Just for Kicks, if you try Filter, it won't break (or shouldn't)

and use StartsWith

Filter(bleh, startsWith(TextInput2.Text))

Unless you think they are looking for string like inside the last night, then we can do another solution

Was this reply helpful? Yes No
Jellman 8 on at

Like (0)

Report
Copy link

Link copied!

Like this?

Was this reply helpful? Yes No
Verified answer

ronaldwalcott 3,866 Moderator on at

Like (1)

Report
Copy link

Link copied!

The other way around

Filter(BadgeList,StartsWith(LastName, TextInput2.Text))

If LastName is a column in BadgeList

Was this reply helpful? Yes No
Michael E. Gernaey 53,963 Moderator on at

Like (1)

Report
Copy link

Link copied!

@Jellman

Yeah sorry was doing 120 things at one.

flip it around as Donald said.

Cheers!

Was this reply helpful? Yes No