ClearCollect and Filter from a lookup column from Dataverse and Selected Gallery

(1) Share

Report

Posted on by Paul DC

Hello, so I have this code here which gives me incompatible types for comparison.

I wonder if there's a way to convert the type to match the text in the gallery selected.

ClearCollect(
    Project_Collection,
    Filter(
        'Projects Hazard Assessments',
        Project_Lookup = Information_Gallery.Selected.Value
    )
)
 

Categories:

General Questions

All responses (2)

Answers (0)

Paul DC 6 on at

Like (0)

Report

ClearCollect and Filter from a lookup column from Dataverse and Selected Gallery

Hi @FLMike

Project Lookup is a LookUp column in Dataverse.

Column type is just a text field. All I have for now were just simple text fields.

I somehow made it work with this code:

ClearCollect(

ProjectCollection,

'Projects Hazard Assessments',

Filter(

'Projects Hazard Assessments',

Project_Lookup.'Project Title' = Information_Gallery.Selected.'Project Title'

)

)

What concerns me now is whenever I select a gallery it shows up the data on my table with 2 rows of text fields.

And what I wanted to happen is to appear the first row of fields and able to input the Hazard Assessment

because on this scenario I just inputted the data through my table.
Suggested answer

Michael E. Gernaey 41,306 Super User 2025 Season 1 on at

Like (0)

Report

ClearCollect and Filter from a lookup column from Dataverse and Selected Gallery

Hi

What it the Column Type and what field type is it bound too in your Gallery. Did you Type Value, or was it the only property on the .Selected?

So, atm no idea if it can be converted because I dont know what it is. So not sure what to convert it to.