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:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

Michael E. Gernaey 53,963 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Paul DC 6 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No