Unanswered

Need help validating a Person field in a form

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a Powerapps app that we're using at a tech support bar to check people in as they walk up. This particular screen is pretty simple: they type their name in the "Requester" field, which is tied to a SharePoint list Person column. It looks up their name, and they can select it and submit (see attachment).

I have another screen that watches the backing SharePoint list and populates a gallery with the names in the list (it's basically the queue). When someone taps their name in the lookup and submits, it shows up fine in the queue. Here's the issue I'm running into: if someone types their name in, but fails to select their name from the lookup and submits as-is, a blank is stored in the SharePoint list instead of their name.

Is there a way that I can validate that field before they submit? I know there are validation techniques in Powerapps, but I'm not sure exactly how to validate that a proper Person was selected before they submit.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

v-sheyu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
hi @Anonymous,
Can you share a bit more about your issue?

Do you want to validate that field before the field is sumitted?

I made a test.

Set the visible property of the submit button to:
If(IsBlank(ComboBox2.Selected.Title),false,true)
When the field you entry is blank ,the button will not be visible.

regards,
eason

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi eason!

Thanks for your reply. I can share a bit more about my issue. The problem isn't people leaving that field blank; it's when they type their name and then click Submit without selecting a name from the lookup dropdown. The resulting SharePoint entry has a blank instead of a name. It only populates the SharePoint entry correctly when they select their name from the dropdown. See my original attachment for the lookup dropdown I'm talking about.

Thanks,
Sean

Was this reply helpful? Yes No
SreeHelper 16 on at

Like (0)

Report
Copy link

Link copied!

Hi,
Combobox has SearchText property to get the user input. If Combobox.Selected.Name is empty, you can use Combobox.SearchText property to find the username and store in SharePoint.

Thanks.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks SreeHelper.

I see a SearchFields property, but not a SearchText one.

Was this reply helpful? Yes No
SaiTeja444 8 on at

Like (0)

Report
Copy link

Link copied!

Here is the work out for me.
I have created a collection. For the multiselect people picker field values storing in the collection.
Now check the collection is empty or not.
ForAll(
cbusername.SelectedItems,
Collect(
ColPeopleToPatch,
{
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims: "i:0#.f|membership|" & ThisRecord.Mail,
Department: "",
DisplayName: ThisRecord.DisplayName,
Email: ThisRecord.Mail,
JobTitle: "",
Picture: ""
}
)
);
ForAll(
cbapproversnames.SelectedItems,
Collect(
ColApproversPersonsToPatch,
{
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims: "i:0#.f|membership|" & ThisRecord.Mail,
Department: "",
DisplayName: ThisRecord.DisplayName,
Email: ThisRecord.Mail,
JobTitle: "",
Picture: ""
}
)
);
If(
IsBlankOrError(ColPeopleToPatch) && IsBlankOrError(ColApproversPersonsToPatch),
Notify(
"User validated",
Information
),
Notify(
"Not found",
Information
)
)

Was this reply helpful? Yes No