Answered

Copy Person Field from a collection to person field on form

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a form that I am trying to load in certain data based off of pre entered data. On a button click I create a collection and want to fill in values needed but I am not sure how to load a person field from a collection to a person field on the form. Is this possible? Any help would be appreciated.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

AGroegelich 140 on at

Like (0)

Report
Copy link

Link copied!
Hi @MAYLIWK,

I am only a newbe on PowerApss myself so I am not sure if this is the correct answer. I would try to set the Default property of the DataCardValue of the field. I presume you only want to the pre entered data when adding a new record, so you have to reckon with that.

The code I would use is something like:
If(MyForm.Mode = FormMode.New, MyCollection.Field1,Parent.Default)

I hope this helps.

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

Like (1)

Report
Copy link

Link copied!
@AGroegelich

Thanks for the response. This was the help I needed. Since this was happening based on a button click on the form, I created a Boolean variable that was set to true when the button was clicked and modified your code.

Thanks for the help.

If(boolUpdate = true, MyCollection.Field1,Parent.Default)

Was this reply helpful? Yes No
v-yutliu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @MAYLIWK ,

Do you want to set person combo box's defaultselecteditems by using the data of a collection?

Could you tell me the data in the collection in details?
You could use this formula to set person combo box's defaultselecteditems:

DefaultSelectedItems for the combo box control, you can use this expression:

Table({ DisplayName:User().FullName, Claims: "i:0#.f|membership|" & User().Email })

For example,if your collection has the data of Email and full name, you could try:

Table({ DisplayName:First(collection).fullname, Claims: "i:0#.f|membership|" & First(collection).Email })

About updating, you could set this person data card's Update:

Combo box.SelectedItems

Best regards,

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

Like (0)

Report
Copy link

Link copied!

One other issue I had with this was that I was trying to work with the actual textbox within the card and not the card itself once I updated the cards default value everything worked.

Was this reply helpful? Yes No