Answered

SharePoint/Power Apps Dual Lookup validation

(0) Share

Report

Posted on by BWH

Hello, I'm new to Power Apps/Canvas. We have a Teams Channel with a Canvas request form that populates a Microsoft list. We have 2 lists within the Teams SharePoint site contents. We created 2 lookup columns, one for each of the 2 items lists. We tried to create the validation for the two lookups within the lists through SharePoint List Settings, no luck. So, we figured we should be able to pull this off with Power Apps and Canvas. Objective; when a user submits a request by filling out the Canvas form through Teams channel, before clicking the Save option, we want only one of the 2 lookups to be selected. Not both, just one of the two. Column names of the 2 lookup lists are Exterior and Interior. Is this when we would have to create a Power App first and apply it to the Canvas form? Any help would be greatly appreciated. TIA

As shown in Canvas

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

BCBuizer 22,844 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @BWH ,

What you could do is to disable the one combobox when the other has an item selected:

DataCardValue4.DisplaMode = If(IsBlank(DataCardVlaue6.Selected),DisplayMode.Edit, Disabled)

Was this reply helpful? Yes No
BWH 11 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi BCBuizer, thank you for your quick reply. Doesn't exactly worked, maybe I'm applying incorrectly.

with DataValueCard6 applied the following. to the DisplayMode

DataCardValue6 DisplayMode field

In preview, with no item selected for the Exterior DataCardValue4, DataCardValue6 is disabled

when an item is selected for Exterior DataCardValue4, DataCardValue6 is disabled

We tried the following, not terrible but works somewhat, added to DataCardValue6 displaymode
If(IsBlank(DataCardValue4.Selected),DisplayMode.Edit,Disabled)

and added to DataValueCard4 displaymode
If(IsBlank(DataCardValue6.Selected),DisplayMode.Edit,Disabled)

We believe we would prefer something more along the lines of, by selecting one, the other is erase/cleared and vice-versa. Also, when the requestor clicks the Save button for the form, it checks if one of the 2 lookup fields has a value deifned and if false, notify the requestor of the required missing value.

Your help is greatly appreciated!

Was this reply helpful? Yes No
Verified answer

BWH 11 on at

Like
a
(0)

Report
Copy link

Link copied!

Was provided solution from another website forum source;

Write this OnChange of DataCardValue4 property: If(DataCardValue4.Selected.Value<>Blank(),Reset(DataCardValue6),false)

Write this OnChange of DataCardValue6 property: If(DataCardValue6.Selected.Value<>Blank(),Reset(DataCardValue4),false)

The above worked prefectly as the solution

Was this reply helpful? Yes No