Check multiselect lookup column and set required field in Powerapps

(0) Share

Report

Posted on by Poweruser32490

I have a multiselect lookup column in SharePoint which stores the value of all the required column for the Powerapp form.

Based on the above configurations, sharepoint columns with internal name Finance and Legal are required as the IsRequired is set to true.

In my datacard in Powerapps New Form, i am setting the required field based on these conditions, but it fails. May i know where i am going wrong?

Datacard Required Field

If(
    LookUp(
        'Data Source',
        'Title1'.Value = DataCardValue48.Selected.Value && 'Type1'.Value = DataCardValue6.Selected.Value&&'Required Field'.Value in "Finance",
        IsRequired
    ) = true,
    true,
    false
)

Categories:

AI Builder

Microsoft Dataverse with Power Apps

GCC, GCCH, DoD - Federal App Makers (FAM)

Connector development

Error handling

Building Power Apps

Experimental features

Governance & administering

Power Apps Pro Dev & ISV

Power Query

General topics

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Suggested answer

Vish WR 1,212 on at

Like (0)

Report
Copy link

Link copied!

@Poweruser32490

Can you try

If(
LookUp(
'Data Source',
'Title1'.Value = DataCardValue48.Selected.Value &&
'Type1'.Value = DataCardValue6.Selected.Value &&
"Finance" in 'Required Field'.Value,
IsRequired
),
true,
false
)

Was this reply helpful? Yes No
Suggested answer

WarrenBelz 155,109 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Poweruser32490,

Firstly @Vish WR is close, but I will add a couple of things.

Firstly, you need to add all criteria as filter conditions (although a comma may also work)

LookUp( 'Data Source', 'Title1'.Value = DataCardValue48.Selected.Value && 'Type1'.Value = DataCardValue6.Selected.Value && "Finance" in 'Required Field'.Value && IsRequired )

However you also have a Delegation issue here with the in parameter, so you can do this
With( { _Data: Filter( 'Data Source', 'Title1'.Value = DataCardValue48.Selected.Value && 'Type1'.Value = DataCardValue6.Selected.Value && IsRequired ) }, !IsBlank( LookUp( _Data, "Finance" in 'Required Field'.Value ) ) )

Also you do not need to include If/true/false if you are returning a Boolean value - a true or false statement as above will return the matching value - I have a blog explaining this. Just use the code above in the Required property of the Data Card.

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
Poweruser32490 70 on at

Like (0)

Report
Copy link

Link copied!
Hi @WarrenBelz,

I used the below code in Required field property of the datacard, but it throws error saying Expected Boolean Value.

Please take a note that the lookup column "Required Field" is a multiselect column and IsRequired is a Yes/No field in SharePoint.

With( { _Data: Filter( 'Data Source', 'Title1'.Value = DataCardValue48.Selected.Value && 'Type1'.Value = DataCardValue6.Selected.Value && IsRequired ) }, LookUp( _Data, "Finance" in 'Required Field'.Value ) )

Was this reply helpful? Yes No
Vish WR 1,212 on at

Like (0)

Report
Copy link

Link copied!

@Poweruser32490

With(
{
_Data:
Filter(
'Data Source',
'Title1'.Value = DataCardValue48.Selected.Value &&
'Type1'.Value = DataCardValue6.Selected.Value &&
IsRequired
)
},
!IsBlank(
LookUp(
_Data,
"Finance" in 'Required Field'.Value
)
)
)

or

With(
{
_Data:
Filter(
'Data Source',
'Title1'.Value = DataCardValue48.Selected.Value &&
'Type1'.Value = DataCardValue6.Selected.Value &&
IsRequired
)
},
!IsBlank(
LookUp(
_Data,
"Finance" in 'Required Field'.Value
)
)
)

Was this reply helpful? Yes No
11manish 1,535 on at

Like (0)

Report
Copy link

Link copied!
The error occurs because the multi-select lookup column returns a table, not a single value, and the LookUp function returns a record instead of a Boolean.

To fix this, you must check for the existence of "Finance" using CountIf within the lookup column and wrap the result with !IsBlank to return a Boolean value.

This ensures the Required property receives a valid true/false result.

Try below :

With( { _Data: Filter( 'Data Source', 'Title1'.Value = DataCardValue48.Selected.Value && 'Type1'.Value = DataCardValue6.Selected.Value && IsRequired = true ) }, !IsBlank( LookUp( _Data, CountIf('Required Field', Value = "Finance") > 0 ) ) )

Was this reply helpful? Yes No
WarrenBelz 155,109 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Poweruser32490,

Please see updated post - original left a line out - dangers of free-typing code without brain engaged properly.

Was this reply helpful? Yes No