Unanswered

Filter Gallery Based on 'In' Not 'Equal'

(0) Share

Report

Posted on by Phineas

5,331 Moderator

Goal:
If 'Document_Name' column of 'Client_Attachment_Library' has any 'items' that have (not equal or match) any of the content in 'Title' column of 'Document_List' then CircleIcon1 should be green else red.

I tried this formula, it didn'twork.
If(Gallery7.Selected.Title in Client_Attachments_Library_Collection.Document_Name, RGBA(255, 0, 0, 1), Color.Red)

I have 'Gallery7' (Source: Document_List_Collection, Specifically 'Title' Column).

I have 'Client_Attachments_Library' (Referencing specifically 'Document_Name').

I have 'Documents_List'.

Gallery7 - I have 'Gallery7' which has 'CircleIcon1'. I want CircleIcon1 'Fill' to be 'Red' or 'Green' based on whether an 'item' in 'Client_Attachment_Library' (Document_Name) has the content of 'Gallery7.Title' (circled below) - which in this case would be 'Driver License'; In this example the circle should be 'Green', as a document with that content in the 'Document_Name' column of the Library does exist.

Client_Attachments_Library - The 'Client_Attachment Library' has a 'Document_Name' column. The content I want to compare is nested within the contents. This column has a document with 'Driver License' in the content (as required and specified in the above).

Document_List - The 'Document_List' is part of the comparison, specifically the 'Title' column.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

WarrenBelz 154,928 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Phineas ,

Before I go anywhere else here, you have Red twice - RGBA(255, 0, 0, 1) is Red RGBA(0, 255, 0, 1) is Green - RGBA is Red/Green/Blue/Alpha with Alpha being transparency as a Decimal.

Was this reply helpful? Yes No
Phineas 5,331 Moderator on at

Like (0)

Report
Copy link

Link copied!

Sorry, just trying to provide as much information as I can.

Goal:
If an item in 'Gallery7 (Document_Title, column)' is in the contents of 'Client_Document_Library (Document_Name, column)', make the 'Gallery7 (CircleIcon1), 'Green' else 'Red'.

The 'Client_Attachments_Library - Dcoument_Name' is formatted by a formula that combines pieces of several fields.

Consequently, the content I'm concerned about is in the middle of 'Client_Attachments_Library - Dcoument_Name',
- in this case 'Drivers License', I can put the content at the beginning or end, but the number of characters will
rarely be the same.

Just trying to understand if there is a way to filter for the specific 30 items in the the 'Document_List - Title' if they appear in the 'Client_Attachments_Library - Dcoument_Name'?

Was this reply helpful? Yes No
WarrenBelz 154,928 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@Phineas ,

You have two problems to address here - your formula will only work for an exact full match of the item and also spaces in your target or source fields will cause it to fail - so

With( { _Data: AddColumns( Client_Attachments_Library_Collection, "DocName", Substitute( Document_Name, " ", "" ) ), _Select: Substitute( Gallery7.Selected.Title, " ", "" ) }, If( CountRows( Filter( _Data, _Select in DocName ) ) > 0, Color.Green, Color.Red ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No