Answered

Auto populate syntax works for for one list but in another form with same config. it does not.

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello All,

I am completely baffeled on this one.

I have 2 canvas apps each with 2 person fields connecting to similar SharePoint lists and both have the O365 Users data connection configured. The goal is to have the user manager auto populate the current user's manager

In the first canvas app I have it working using the syntax below on a person field populating the 'Default' property

Office365Users.ManagerV2(User().Email).displayName

But in the second canvas app the exact same configuration doesn't work. I get the error;

Nice and ambiguous.

Anyone have any clue what may be happening and how I may fix it?

Thank you in Advance for any and all advice.

Cheers!

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

WarrenBelz 156,382 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous ,

What type of control is DataCardValue3 ? The code is valid if you want a Text result. You also obviously need Office365Users connected in your Data Sources.

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @WarrenBelz Thank you for your reply.

As I mentioned above, the control is a person control; I have the O365Users connected as well. I have this configured already in another similar app and it is working.
Data connections

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,382 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
@Anonymous ,

I meant the control type - is it a Combo Box ? If so you might need in the DefaultSelectedItems

{DisplayName: Office365Users.ManagerV2(User().Email).displayName}

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @WarrenBelz

Yes, it is a combo box. I had tried that as well and I receive the error below;
I just don't understand what I did to get it working in the other one.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz Ugh, I forgot a the { Thank you so much.! That worked for me. It's different from my other app, but at this point, if its working . . .

Thanks again

Was this reply helpful? Yes No
WarrenBelz 156,382 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous ,

When you change the Items of Combo Boxes, you need the DefaultSelecteditems to reflect the data you want to see in it. A combo Box contains a Table and displays one of the fields in this Table (although there may be only one) in the item shown as selected by default. As it is a Table, it needs to be enclosed in {} brackets, with the two elements - the table field name displayed

ComboBoxName.Selected.FieldName

and then the text value you want to display in it. So in a simple example, your Combo Box Items was the Widget field in the List Devices

Devices.Widgets

and you wanted the DefaultSelectedItems to be the MyWidget field in the current list, it would be

{Widgets: ThisItem.MyWidget}

Was this reply helpful? Yes No