Exactin/In when using two text fields (1 exists within 10)

(0) Share

Report

Posted on by Axeum

I am currently using a SharePoint list ID number as my unique identifier and then patching that number into a separate for event sign ups.

If want to limit the view so that people can only see the gallery items where their ID exists within the Event Sign Up field.

Currently formula is as follows

SortByColumns(Search(Filter('(Events)', Value(VarProfile.ID) exactin 'Users Signed Up'),

TextSearchBox1_3.Text, "Title"),

"EventDate", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending))

As I mentioned. My VarProfile.ID = 1 and it's registering when ID's 10-19 are signed up to that event.

Any help on limiting this would be appreciated, thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Axeum ,

It seems you would like to filter the Events list by User signed up value that equals to VarProfile.ID. Please try below formula:

SortByColumns(Search(Filter('Events', 'Users Signed Up' = Value(VarProfile.ID)), TextSearchBox1_3.Text, "Title"), "EventDate", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending))

The in and exactin operators are used to search for case-insensitive/sensitive strings. You can understand that this means "contains".

Operators and Identifiers in Power Apps - Power Platform | Microsoft Learn

Best regards,

Was this reply helpful? Yes No