Combobox Requiered Filed not working for People Picker

(0) Share

Report

Posted on by mateuszwrona

Hi,

I have built Combobox based on Office365 - People Picker.

Combobox Item:

Filter(Office365Users.SearchUser({searchTerm: Trim(Self.SearchText),

isSearchTermRequiered: true, top:999}), "@aaa.com" in Mail && Not("EXT" in Mail) && Not("(aaa- Global)" in DisplayName) && Not("(aaa- FI)" in DisplayName))

Card Update:

{

'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",

Claims: DataCardValue31.Selected.Mail,

DisplayName: DataCardValue31.Selected.DisplayName,

Email: ""

}

Combobox should be requiered but if I change field to True nothing will change. It is still possible to submit the form.

I know that there is a problem with Defaultselecteditem but I dont know what should be there, now I have Parent.Defult or Thisitem.Columname.

I have a few other comoboxes in the file - based on choices from SP - and they work.

One more is not working related to choices in SP but with update:

Coalesce (DataCardValue10.Selected, {

Value: DataCardValue10.SearchText ,

'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"})

This one is also not working.

Could you please help me with it?

Categories:

Building Power Apps

All responses (5)

Answers (0)

Sort by

WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @mateuszwrona ,

Two issues - one not relating to your question, but the Data Card Update should be

{ Claims: "i:0#.f|membership|" & Lower(DataCardValue31.Selected.Mail), DisplayName: DataCardValue31.Selected.DisplayName, Email: DataCardValue31.Selected.Mail }

As to the required, if you set the Data Card to Required, then your Submit code should be

If( YourFormName.Valid, Submit(YourFormName) )

Please click Accept as solution 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 giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
mateuszwrona 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz

thanks, it works for People Picker. Not possible to submit the form.
Still I dont get the error message in the area below the field as I do with standard combobox.

Any idea how to fix it? Also still struggle with second combobox based on the Update field below:

Coalesce (DataCardValue10.Selected, {
Value: DataCardValue10.SearchText ,
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"})
mateuszwrona 12 on at

Like
a
(0)

Report
Copy link

Link copied!

also for this people picker even if Required is False, it return the error, I need to always choose the person there. Dont fully understand why
WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@mateuszwrona ,

What type of field are you writing back to in the second item and what is the Items of the Combo Box.

Also what to you mean by Not possible to submit the form ?
mateuszwrona 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank @WarrenBelz
I coudnt solve my issue so I have found workaround.
I just disabled Submit button:

If(Len(DataCardValue22.Selected.Value) > 0,
If(DataCardValue22.Selected.Value = "New Case",
If(Len(DataCardValue10.SearchText) +Len(DataCardValue10.Selected.Value) > 0 && Len(ComboBox4_2.Selected.DisplayName) > 0 && Len(DataCardValue17.Selected.DisplayName) > 0 && Len(DataCardValue31.Selected.DisplayName) > 0 ,
DisplayMode.Edit, DisplayMode.Disabled),
If(Len(DataCardValue10.SearchText) +Len(DataCardValue10.Selected.Value) > 0 , DisplayMode.Edit, DisplayMode.Disabled)),DisplayMode.Disabled)

Maybe not the better solution but it works 🙂