web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps This data type is unsu...

Power Apps

Unanswered

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

(0) Share

Report

Report

Posted on by B_David37

4

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 Img

All responses (2)

Answers Img

Answers (0)

CU-18081211-6 9,270 Moderator on at

Like (0)

Report
Copy link

Link copied!
@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
Copy link

Link copied!

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

Join the conversation