cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Responsive Resident
Responsive Resident

Custom dropdown Person Column

Hi,

 

I wish to have a dropdown column with people to patch to sharepoint column, however if the user is offline the list doesnt populate, what is the syntax to fill in the items?

 

 

7 REPLIES 7
Highlighted
Super User
Super User

Re: Custom dropdown Person Column

@shaneOZ 

You will not be able to get the list of people if the user is offline.

However, you can store a cache of the users locally so that when they are offline, you can search through that or use it as a datasource.

You'll want to take a look at the LoadData and SaveData functions to perform this operation.

What you store in the local data will depend on where you are getting the people list from to begin with.

 

I hope this is helpful for you.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Highlighted
Responsive Resident
Responsive Resident

Re: Custom dropdown Person Column

Hi Randy,

 

If im understanding you correctly,

 

ive got to create a collection using Savedata and then load that data using Loaddata on the apps start up?

 

Could you give me a brief example of how i am able to do this using a person column as its the only thing stopping my apps from being completely offline? As there is no youtube videos and the wiki using twitter as an example does not make sense to me?

 

 

Highlighted
Super User
Super User

Re: Custom dropdown Person Column

@shaneOZ 

So, are you trying then to cache the entire Office 365 directory of people?

That would be the first place to start - determine what you want to cache.

 

Keep in mind, yes, you can cache all of them, but you're going to have to change functionality of your people picker controls.  They will not be able to get their data and you will then need to supply it.

But, first - is this a sub list of names or the entire directory?

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Highlighted
Responsive Resident
Responsive Resident

Re: Custom dropdown Person Column

It will just be a sub list of names as the entire directory is overkill, it will only need a dozen names at most.

Highlighted
Super User
Super User

Re: Custom dropdown Person Column

@shaneOZ 

So, I'd suggest then potentially creating a list with the people in it that you want.  Then load that list and SaveData on it.  Otherwise you'd have to query the entire directory and cache it...which you don't want.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Highlighted
Responsive Resident
Responsive Resident

Re: Custom dropdown Person Column

So how do i create this list?

 

Where do i create it?

 

do i just create a list in sharepoint? in powerapps? do i use a dropdown?

 

Highlighted
Super User
Super User

Re: Custom dropdown Person Column

@shaneOZ 

The choice of where and how is yours to make.  

My recommendation is that you have a SharePoint list with all the names in it that are needed.

Then, OnStart of your App, if your connected, collect that list and SaveData.  If not, then LoadData of an existing save.  Obviously, the user will have to be connected at some point prior to saving and using a Loaded collection.

After that, since you did this OnStart, the collection would then be available for you for DropDowns or whatever other controls you need to use.

 

Hope that sheds some more information...if still having issues, post back.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.

Helpful resources

Announcements
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (10,181)