Unanswered

Need help validating a Person field in a form

(1) Share

Report

Posted on by Community Power Pla...

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.

App example.png

All responses (5)

Answers (0)

SaiTeja444 8 on at

Like (0)

Report

Re: Need help validating a Person field in a form

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
)
)
Community Power Pla... on at

Like (0)

Report

Re: Need help validating a Person field in a form

Thanks SreeHelper.

I see a SearchFields property, but not a SearchText one.
SreeHelper 16 on at

Like (0)

Report

Re: Need help validating a Person field in a form

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.
Community Power Pla... on at

Like (0)

Report

Re: Need help validating a Person field in a form

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
v-sheyu-msft on at

Like (0)

Report
Re: Need help validating a Person field in a form

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