Unanswered

Cant compare Record to Table

(0) Share

Report

Posted on by NoobPower

I have the following code located on a button for the onSelect function.

If(ddFPCONStandard.Selected.Value = "DoD", ClearCollect(
 colFilterLevel,
 Filter(
 'DoD FPCON Measures',
 'Measure Type'.Value = ddFPCONStandard.Selected.Value && Level.Value = ddFPCONStandard_1.Selected.Value
 )),ClearCollect(colFilterLevel,Filter(
	'DoD FPCON Measures',
	'Measure Type'.Value = ddFPCONStandard.Selected.Value && Level.Value = ddFPCONStandard_1.Selected.Value
	&& Group.Value = ddFPCONStandard_3.Selected)));
Navigate(screenFPCONLevel)

Everything works fine until the last section with Group.Value = ddFPCONStandard_3.Selected)));. This is where I get the error and cant compare table, record. How would I go about changing one of these to match?

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (0)

turnerj3 2,039 on at

Like (0)

Report

@NoobPower ,
See if Value is an option on ddFPCONStandard_3.Selected.Value

Was this reply helpful? Yes No
NoobPower 17 on at

Like (0)

Report
I tried that and it changes the error to these types can't be compared: Table, Error.

If it helps the ddFPCONStandard_3.Selected.Value is from:
Filter('NWK - Projects', ID = ddFPCONStandard_2.Selected.ID)
Group in this case is a text field.

Was this reply helpful? Yes No
Uditha_ISH 45 on at

Like (0)

Report
In the last section, you equal to record and type. Thats why power apps get Erro,

If(ddFPCONStandard.Selected.Value = "DoD", ClearCollect( colFilterLevel, Filter( 'DoD FPCON Measures', 'Measure Type'.Value = ddFPCONStandard.Selected.Value && Level.Value = ddFPCONStandard_1.Selected.Value )),ClearCollect(colFilterLevel,Filter( 'DoD FPCON Measures', 'Measure Type'.Value = ddFPCONStandard.Selected.Value && Level.Value = ddFPCONStandard_1.Selected.Value && Group.Value = ddFPCONStandard_3.Selected.Value))); Navigate(screenFPCONLevel)

Try this.

Was this reply helpful? Yes No
Pstork1 68,707 Most Valuable Professional on at

Like (0)

Report

To compare a record to a table you need to use the 'in' operator. If the record exists in the table it will be true, if it doesn't it will be false. So is either Group.Value or ddFPCONStandard_3 setup to allow multiple selections?

Was this reply helpful? Yes No
NoobPower 17 on at

Like (0)

Report

The value being sent to ddFPCONStandard_3 is a multiple selection.

Was this reply helpful? Yes No
turnerj3 2,039 on at

Like (0)

Report

See if SelectedItems is an option. That should be a table.

Was this reply helpful? Yes No
NoobPower 17 on at

Like (0)

Report
When I try SelectedItems it gives an error and says it isnt recognized. Could part of my problem be the filter formula?
Filter('NWK - Projects', ID = ddFPCONStandard_2.Selected.ID)
I have it filtering by ID, the label shows the text of the Group column, but would the backend filter only pull over the ID? I would guess I would want it to match by ID, but bring the group column data over?

Was this reply helpful? Yes No
NoobPower 17 on at

Like (1)

Report

Looks like I needed to do ddFPCONStandard_3.Selected.Group

Was this reply helpful? Yes No