I have a sharepoint list as datasource
One column is set to text - one row.
I want to force my user to input the exact same data in my textfield by having a combobox in my form in powerapps.
But it complains about expecting a record value.
How can i use a combobox and keep my text column in my datasource?
Unlock the data card. Hide the text box in the card. Put a Dropdown control in the card. Make the Items property of the dropdown
Change the Update property of the card to Dropdown1.Selected.Value
(A dropdown control is better than a combo box for your issue).
I need to have multiselect options in my dropdown so i guess im forced to use a combobox.
but i cant make it work still.
i can save data now to my textfield.
but i cant get it back to let the user edit the options when editing the form.
I'm having a hard time parsing how you're trying to set this up. Are you wanting the combobox to pull all the records in that column in sharepoint (defined as a single line of text) and then populate those items as options in the combobox?
If so, I think you can easily do that with ShowColumns(). Use the following:
This is, of course, assuming that you don't have repeat entries in that column you want to be consolidated into one choice. I'm assuming all choices in that column are distinct.
Yes i think we are talking about the same thing.
My column data looks like this in sharepoint:
datavalue1; datavalue2; datavalue3.
It is defined as a singel line of text.
In powerapps in my form when i Add new data i use a dropwdown to select one or multiple options: datavalue1, datavalue2.... etc.
Then when i want to Edit the form, i want to populate the dropdown again with the selected records from creating the row. But since the data is stored in singel line of text my dropdown is just empty.... the data is there but it is not populated in my Edit form.
Is showcolumn() the solution for this?
Where do i put the code (ShowColumns(SharePointListSource, "ColumnName"))?
I have many rows in my datasource but only 5 options in my combobox for entering data.
so the data is repeating in the coulmn...
and so on.....
Just so I have it straight in my head: a single record in your column is "datavalue1;datavalue2;" meaning you need PowerApps to evaluate the string of each record and produce each distinct "datavalue#" (with no duplicates) as its own option?
I'm thinking you may want to pull that column into a PowerApps collection and do the data manipulation there. Is there a reason the SharePoint list itself isn't using a choice column instead? Are new datavalues added regularly?
I think I'm making this harder than it needs to be. I'm guessing you have already populated your items in the ComboBox items field and don't necessarily need them to pull from anywhere. If you haven't then click on your ComboBox, set its Items property to
["datavalue1", "datavalue2", "datavalue3", "datavalue4", "datavalue5"]
What you want is to save the data back in text format as a string to SharePoint. I think if you go to the datacard's Update property and enter
Concat(YourComboBoxName.SelectedItems, Value, ";")
you'll get what you're looking for. If you want to add a space, remember to put it inside the quotes where the semicolon is.
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand