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:

Using Apps Using Formulas

General Questions

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

SkiDK 1,016 on at

Like (0)

Report
Re: Error using IF statement in COLLECTION

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) } ) );

Was this reply helpful? Yes No
Data_Enthusiast 383 on at

Like (0)

Report

Re: Error using IF statement in COLLECTION

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

Was this reply helpful? Yes No
Data_Enthusiast 383 on at

Like (1)

Report

Re: Error using IF statement in COLLECTION

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.

Was this reply helpful? Yes No