Unanswered

This data type is unsupported for evaluation in powerapps while retrieving Option set value.

(0) Share

Report

Posted on by B_David37

I am trying to build Scrum board using data verse table. Option set values are not showing While retrieving option set value using filter condition.

This data type is unsupported for evaluation is showing as value.

ClearCollect(
WICOL,
Filter(
Choices('Work items (Accounts)'),
Text(Value) <> "Inprogress"
)
);
Clear(COLWISeq);
ForAll(
Sequence(CountRows(WICOL)),
Collect(
COLWISeq,
{
Value: Last(
FirstN(
WICOL,
ThisRecord.Value
)
).Value,
RowNo: Value
}
)
);

can someone help me to sort this issue please?

Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

CU-18081211-6 9,270 Moderator on at

Like (0)

Report
@B_David37 ,

I don't think that is something wrong with your formula. This instant results show is not quite accurate in situation like this. Just use an "old fashion" way to check the collection. Add a gallery with items property set to COLWISeq collection, two labels inside it with text property set to ThisItem.Value for the first one and ThisItem.RowNo for the second and run the app in playmode.

Please take in consideration also this approach (not too different from yours) with Index function as help.

ClearCollect( WICOL, Filter( Choices('Work items (Accounts)'), Text(Value) <> "Inprogress" ) ); ForAll( Sequence(CountRows(WICOL)), Collect( COLWISeq, { Value: Index( WICOL, Value ).Value, RowNo: Value } ) );

Hope it helps !

Was this reply helpful? Yes No
B_David37 4 on at

Like (0)

Report

HI @gabibalaban ,
Thanks for the reply!
I am able to show the value in the Label as you said, But, I want to change the status of the field when I click the left and right navigation icons.
For that i used patch function.
Patch(
Accounts,
ThisItem,
{'Work items': {Value:LookUp(COLWISeq,RowNo = Value(RowNo_LBL.Text)+1).Value}}
);
But it is giving error like "Does not match the expecting type".
Can you help me on this please?

Was this reply helpful? Yes No