Show the current logged on user in a combo box on a new form and the SharePoint value when editing the form

(0) Share

Report

Posted on by Community Power Pla...

In a combo box, how do I show the currently logged-on user if the form is NEW and if it's not new show the information from the SharePoint list?

I have this formula on the DefaultSelectedItems of the Combo box:

If(EditForm1.Mode=FormMode.New,
 Office365Users.MyProfile(),
 ThisItem.SharepointColumn
)

This gives me an error on the entire formula.

I've tried many different variations on many different properties, but I can't seem to get the current user to display on a new form and the SharePoint value to display when editing a form.

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (0)

Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report
@Anonymous -

Assuming the Items property of that ComboBox control contains something along the lines of:

Choices([@'Your List'].SharePointColumn

On the DefaultSelectedItems property, use:

Coalesce( Parent.Default, { Claims: "i:0#.f|membership|" & User().Email, Department: "", DisplayName: User().FullName, Email: User().Email, JobTitle: "", Picture: "" } )

Was this reply helpful? Yes No