cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Khole
Helper I
Helper I

ComboBox

I am trying to create a custom form connected to a list on sharepoint. I have 3 fields that I need the user to fill in email, but i want to pull it out from Office365 Users. How do i go about this? Note that i have already tried using 'Office365Users.SearchUser({searchTerm:ComboBox11.SearchText,top:10})' in the item property but i still domt get a dropdown list of users.

17 REPLIES 17
StalinPonnusamy
Super User
Super User

Hi @Khole 

 

There is a lot of steps on this requirement. Let me try to direct you to the right path to start, this will help you to build it more.

 

  • Type "Automated Cloud Flow"
  • Search 'SharePoint"
  • Trigger "When an item is created or modified"

Here is the flow look like

StalinPonnusamy_0-1635219583232.png

If Yes and If No expanded from the above image

StalinPonnusamy_1-1635219642111.png

 

  • You can extend this to Approver 3 and CEO
  • Need to make sure this flow only will be triggered when the condition is met. It means some status or something instead of all the time.

 

Let me know what condition this email approval should be kicked off. For example, approval start when the status is completed in the below example

StalinPonnusamy_2-1635219909433.png

 

@equals(triggerOutputs()?['body/status_label'],'completed')

 

  • Click "..." three-dot
  • Click Settings
  • Set the Trigger condition based on your requirement

StalinPonnusamy_3-1635219994705.png

 


Thanks,
Stalin - Learn To Illuminate

Thank you once again. 

on my powerapps, the selected option from a dropdown list does not show on my view screen.

 

StalinPonnusamy
Super User
Super User

Hi @Khole 

 

I assume you are using the form to display data on the view screen.

 

For the Combo box, Set the DefaultSelectedItems property of Datacardvalue to Parent.Default.

StalinPonnusamy_0-1635339482544.png

 

If you use Label control to display the dropdown(Choice) value then Set Text property to 

ThisItem.ChoiceColumn.Value

StalinPonnusamy_1-1635339503886.png

 


Thanks,
Stalin - Learn To Illuminate

Thank you for always replying.

I am not using a Label and my Default selected items is on that already

 

For my Items property, Office365Users.SearchUser({ searchTerm:"Mail"}) is what i used.

Maybe that could help you help me. 

 

 

StalinPonnusamy
Super User
Super User

Hi @Khole 

 

Can you try this

{
    Claims: "i:0#.f|membership|" & ThisItem.'PersonColumnName'.Email,
    Department: "",
    DisplayName: ThisItem.'PersonColumnName'.DisplayName,
    Email: ThisItem.'PersonColumnName'.Email,
    JobTitle: "",
    Picture: ""
}

As the Item property?

 

StalinPonnusamy
Super User
Super User

As DefaultSelecteditems property

 

StalinPonnusamy_0-1635343203036.png

 

StalinPonnusamy_1-1635343240227.png

 

Still having the same issue.

I think i am having this issue because i customized the item property. Reason is i added a new field with the original item property and i got a display

Helpful resources

Announcements
Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

<
Users online (3,291)