Combox NOT capturing the selected value in Datasource

(0) Share

Report

Posted on by Newbie12

227

Hi,

My Datasource is Excel file, which contains column "Assigned to". The default format of the column is Text. I used the Edit form to capture the "Assigned to" field. Initially, it was text field. But I deleted the field because I needed multiple users so I used Combobox and connected to Office365 connector so user can search and select multiple users. I can select and search multiple users in Combobox. However, the selected names are NOT getting captured in Excel.

I am not sure what is the issue ?

Thanks in advance for your time!

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

Verified answer

eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

I suggest you insert the Assigned To field back on your form. Then get the input of the Combobox into the Assigned To field on your form. By so doing, selected items names / items will populate the field which would subsequently be sent to the Excel datasource:

So assuming the Items property of the combobox is:

Office365Users.SearchUser({searchTerm:""}).DisplayName

In the Default of the Assigned To field put:

If(FormName.Mode = FormMode.Edit, Parent.Default, ComboBox2.Selected.DisplayName)

Where multiple names would be selected in the combobox, use:

If(FormName.Mode = FormMode.Edit, Parent.Default, Concat(ComboBox2.SelectedItems.DisplayName,DisplayName, ", "))

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Newbie12 227 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you!
I think code should be other way round ?
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Please can you explain the other way around?

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Newbie12 227 on at

Like
a
(0)

Report
Copy link

Link copied!

I think it shud be as below..I could be wrong

If(FormMode=Edit, Concat(),Parent.Default)
eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

That is not correct. If the form is in new Mode, there is nothing to show because you are entering new data. Therefore it cannot be Parent.Default

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.