Error using IF statement in COLLECTION

(0) Share

Report

Posted on by Data_Enthusiast

383

Hi Power Apps Community,

I am trying to create a collection of the items in a Gallery.

Issue: The values which I am trying to collect are from two controls (Radio and Text). Depending on the control used, I would like to collect the relevant data. As seen below, I have been trying to incorporate the IF statement in the Collection.

ForAll(Gallery.AllItems,
 Collect(CollectionName,
 {Field1:Title.Text,
 Field2: If('Field' = "Value", Radio.Selected.Value, TextInput.Text}));

I would appreciate any help.

Thank you in advance.

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

SkiDK 1,016 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Data_Enthusiast
There is a mistake in your syntax. You don't close the if statement.
ForAll( Gallery.AllItems, Collect( CollectionName, { Field1: Title.Text, Field2: If('Field' = "Value", Radio.Selected.Value, TextInput.Text) } ) );
Data_Enthusiast 383 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @SkiDK
Thank you for the response.
When adding your update, I get the following issue:
Seems to not like the equal sign.
Data_Enthusiast 383 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @SkiDK
Please ignore the previous comment. I made a mistake on my side. Your formula provided does work 😀
I guess it does not help that I rush 😅
Thank you for the help.