Unanswered

Expand/Collapse button won't working

(0) Share

Report

Posted on by AustineHype

Hello,

I have a nested gallery with a list of items however I would like to input a button that expands and collapse gallery items with the following formula:

Onselect ->

If(IsEmpty(colCollapseExpandGroup),

Collect(colCollapseExpandGroup,

ForAll(Distinct(colProjectData,'Project'),

{ID: LookUp(colProjectDate,'Project'=Result).ID,'Project':Result}

)

Clear(colCollapseExpandGroup)

)

the error message I get is mostly ' Incompatible type, The 'ID' column in the data source you are updating expects a 'Number'Type and you are using a 'Error' type. and this is the same for the rest

Képernyőkép 2023-09-22 135945.png

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

cha_cha 4,932 Moderator on at

Like (0)

Report
Hello @AustineHype

In your code given, you use colProjectDate, which I suspect is just a typo.

Try this; it's a shorter version with a similar concept. If in case of error, please reply here

If(IsEmpty(colCollapseExpandGroup), Collect(colCollapseExpandGroup, ForAll(Distinct(colProjectData,'Project') As X, {ID: X.ID,'Project':X} ) ) , Clear(colCollapseExpandGroup) )

Was this reply helpful? Yes No
AustineHype 16 on at

Like (0)

Report

Hi @cha_cha

Thanks for your quick reply, I have tried this formula but am unsure what I should put in the 'X' could you please advise?

Was this reply helpful? Yes No
cha_cha 4,932 Moderator on at

Like (0)

Report

Hello @AustineHype

Just the provided code as it is. X pertains to ThisRecord keyword. In my provided code, it means it is the current item in the ForAll function.

Was this reply helpful? Yes No