Unanswered

Record Text Error

(1) Share

Report

Posted on by Dunes

Hi All,

I have two Sharepoint lists. The Requestors has a field called Division which is a choice field. On my page in Power Apps I have a field called crdDivision which is a single select combo box. I am trying to take the "crdDivision" combo box value and match on the "RequestorsDivision" in the SharePoint list...however I am getting an error of "Incompatible Types Record Text". How do I compare these two. Can I not compare a Sharepoint choice field to a selected value in a combo box?

Thank you in advance...

Set(
varApprovers,
LookUp(
ApproversTree,
ApproversDivision.Value = LookUp(
Requestors,
RequestorsDivision = crdDivision.Selected.Value <<<<<<<<<<<<<<<<<Error is here
).RequestorsDivision.Value && (Value(crdRequested_Value.Value) >= MinAmount && Value(crdRequested_Value.Value)<=MaxAmount )
).Approvers
);

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
hey

can u try this modification please:

Set( varApprovers, LookUp( ApproversTree, ApproversDivision.Value = LookUp( Requestors, RequestorsDivision.Value = crdDivision.Selected.Value ).RequestorsDivision.Value && (Value(crdRequested_Value.Value) >= MinAmount && Value(crdRequested_Value.Value) <= MaxAmount) ).Approvers );

If the Post help you solve your issue, please mark it as verified answer and give it a like so we can help other in the community with similar issues

Greetings

Was this reply helpful? Yes No
mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

hey

have you had the chance of trying what i suggested?

if it helped please mark as verified answer so we can also help others with similar issues

cheers

Was this reply helpful? Yes No