PowerApps App with dropdown populated with person column from a SharePoint

(0) Share

Report

Posted on by Hermit1

Hi,

I've used the standard SharePoint PowerApps template that gives you the 3-screen app and amended it slightly to suit our needs. The App creates and maintains entries in the SharePoint list - our "database".

I want to create a dropdown for a field called "Project Manager" that uses a Person field from a separate SharePoint list ("Team List") but I'm not able to get it to work properly.

I get [object, Object] in the field display and changes are not saving the database.

On Select: ClearCollect(CollMgr,AddColumns('Team List',"Project Manager Name",'Project Manager'.DisplayName))

Items: SortByColumns(CollMgr.'Project Manager Name',"Project Manager Name")

Update: DataCardValue77.Selected

The reason I'm using a Person column is so that I can generate an approval PowerAutomate Flow and send status update emails to the Project Manager.

What am I doing wrong? I've hunted for similar solutions but none seems to fit this case.

Thanks,
Patrick

Categories:

Building Power Apps

All responses (1)

Answers (0)

WarrenBelz 156,750 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Hermit1 ,

That should work (I also just confirmed in a test here) - you can just make the Items of your Combo Box

AddColumns( 'Team List', "Project Manager Name", 'Project Manager'.DisplayName )

Just make sure you display 'Project Manager Name' in your control.

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.

Visit my blog Practical Power Apps