Answered

Prepopulate choice form field with data from a gallery label field that is a choice type

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a SP list that is displaying view only data in a gallery (Just one item). On the page the user will use that information to update an item. At the bottom of the screen I have form fields related to the list above that are editable so the user can update and save.

I have title which pre-populated (using default) from the title label in the gallery no issue. BUT then one of the labels is choice field in the gallery, it is displaying using ThisItem.Goal.Value in the gallery (this is all correct). However when I added the goal field to the form below and tried to prepopulate it with the label in the gallery that uses (ThisItem.Goal.Value) it will not work. These two fields are required to update the list via the form. Any suggestions?

Categories:

Building Power Apps

All responses (19)

Answers (1)

Sort by

WarrenBelz 156,532 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Try

{Value:ThisItem.Goal.Value}

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.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
It did not error out but unfortunately it did not work either. I tried:

The following:
updating the Goal Data card default value to what you mentioned
Updating the datacard value items field to what you mentioned
I attached screenshots in case I updated the wrong parameters. Also note how under title it says testing in the form, then at the top in the gallery Project title reads testing. That was the only label I was able to get to work 😕
WarrenBelz 156,532 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

I see you are using a Combo Box on a Choice field - the DefaultSelectedItems should be

{Value:ThisItem.Goal}

and the Update of the card would be

{Value:DataCardValue8.Selected.Goal}

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.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Unfortunately no luck. I did include a shot of the error though. Note a.png. Goal 1 is what I am trying to pre-populate it will change with every item opened.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

forgot attachments
WarrenBelz 156,532 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

OK @Anonymous ,

I can see it all now - why are you trying to update from a label that already displays the value of the field?
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

The screen is meant for the approver to just review the content in the gallery. The only field at the bottom they need to edit (update) is the project request and comments (optional). However, because the form requires the title, and goal selection I was forced to put on the form otherwise it will not submit. My plan was to get it to prepopulate then just hide those fields. I am open to other suggestions. But ultimately the top (gallery) is review no edit. Then I want the user to update the project request field which is a choice and select approve/reject.
WarrenBelz 156,532 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous ,

Is this label inside a card on the Form? If so, the Text needs to be ThisItem.Goal
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

No the label is inside a gallery. The form is separate below.
WarrenBelz 156,532 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous ,

Can we please try to summarise this and what your issue is as the solution should be simple.

Focusing on the combo box please provide (in text) the Items, Default and DefaultSelectedItems, the Update of the card it is contained in and the DataSource and Item of the Form.