Answered

Set combobox default value based on a selected row of datatable

(0) Share

Report

Posted on by RaphaelMelo

Hi guys!

I am trying to create a copy function to create a new form submission.

The marked button should load a new form with some fields of the selected row.

The problem started when I tried to set the "email_solicitante" cell from the data table as the default value for the "Solicitante" combo box field.

I'm using this as the data source for my combo.

Filter(Office365Users.SearchUserV2({searchTerm:DataCardValue17.SearchText}).value, Country="Brazil", "MyDomain.com" in Mail)

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

AndrewR1 1,572 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @RaphaelMelo I think you need to set the DefaultSelectedItems property of the combo box this would just be something like:

If(!IsBlank(UserYouHaveSelect),UserYouHaveSelect.email_solicitante)

This is very generic and would not work if you copy it over but this is the general idea for you if you can give me more information on what the table structure is like and which field is being selected I could give you a more specific answer.

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. Remember, you can accept more than one post as a solution. If the content was useful in other ways, please consider giving it Thumbs Up.

Thanks
Andrew
Verified answer

RaphaelMelo 33 on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks for helping!
this gives me a glimpse of how I should handle that.

On the "On Select" propriety of the copy button, I add a boolean variable to manage the copy activity.
Set(Copy,true); ResetForm(Form_frmCtrl);NewForm(Form_frmCtrl);Set(varFormVisible, true);

and on the combo box "DefaultSelectedItems" property I set it like this:
If(Copy, //true If(!IsBlank(DataTable_frmCtrl.Selected), First(Filter(Office365Users.SearchUserV2({searchTerm:DataTable_frmCtrl.Selected.Email_Solicitante}).value, Country="Brazil", "MyDomain.com" in Mail)) ) //false )

and to do the same with any other form field, I have to put a condition to check if the Copy value is "true", as an example for another text field on the form:
If(Copy, //true If(!IsBlank(DataTable_frmCtrl.Selected),DataTable_frmCtrl.Selected.Ticket_ESS), //false "" )