Unanswered

PowerApps Combobox to Sharepoint

(0) Share

Report

Posted on by LeeCarver

I've done some searching here and on StackExchange, but haven't been able to find a direct solution to my issue although I believe I have come close. I have a Document Library that I have created a form for to upload new files via a controlled/standardized questionnaire. The form gathers a single file plus information on the Client, Description of Document, and Category. The Category field in SharePoint is a Choice column, allowing for multiple selections of different category types to tag the document for indexing/searching.

On the form I have a ComboBox that pulls its values from a separate list in SharePoint that mirrors the values in the Category field. I want to take the values the user selects in this ComboBox and move them to the SharePoint list. Playing around with the code, I've been able to migrate a string such as "Option 1, Option 2" to SharePoint, but the values are not separate and thus not searchable on their own (i.e. will not come up if you do a filter on the column for Option 1). I have seen some "solutions" for similar problems that state I need to migrate the string to Power Automate and then within Power Automate, use the split function to create an array and have the Choice field populated with the array, but have not been able to get this work as of yet

Am I approaching this the right way? Is there a simpler method for doing this? Or is the split function the appropriate way to go? Does anyone have any clear resources for referencing in doing such a task? Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

WarrenBelz 156,384 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @LeeCarver ,
To summarise all of this, you want to send the selected items of a multi-select combo box to a SharePoint Text field as comma separated values? If this is the case, coming from the OnChange of the combo box
Patch( YourSPListName ThisItem, { YourTextFieldName: Concat( YourComboBoxName.SelectedItems, Value & ", " ) } )
Note Value may be different depending on the Items of your Combo Box
Is this what you are asking?

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.

Was this reply helpful? Yes No
LeeCarver 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for the response!

Not entirely by my understanding, so if I am miscategorizing it, please let me know. I am trying to send the selected items from a form's combobox ("CategoryBox") to a SP Document Library ("Engagements") where a column ("Category") is a Choice field (dropdown, multi-select). I haven't been able to figure out how to do this. The closest I've come is reading some discussions on this board stating you need to convert the form combobox to a string and then in the workflow, convert it to an array to update the file properties.

Does this change your approach at all?

Was this reply helpful? Yes No
LeeCarver 6 on at

Like
a
(0)

Report
Copy link

Link copied!
@WarrenBelz - As some additional information on what I'm doing on the backend, I've created a workflow as follows:
PowerApps initializes workflow
Initialize varClient as string; value is set to Client_Value
Initialize varDesc as string; value is set to Desc_Value
Initialize varCategory as object; value is set to Category_Value
Create file
Update file properties
Fields of Document Library are updated with corresponding varX values
Respond to PowerApp with link to Document file
Within the App itself, on the submit button, I'm asking it to do the follow:

Set(varEngagement, JSON(Image2.Image,JSONFormat.IncludeBinaryData));
Set(varBase64Only, Mid(varEngagement, Find(",", varEngagement)+1, Len(varEngagement) - Find(",", varEngagement) - 1) );
Set(varFileLink, EngagementWorkflow.Run(ClientCardValue.Text,DescCardValue.Text,CategoryCardValue.SelectedItems,Last(AttachmentControl.Attachments).Name, varBase64Only).splink);

What I can't figure out how to do is to make the CategoryCardValue work in passing data. The formula above doesn't work because the system is expecting a Record. And if I pass a concatenated string, the values are not separated to be searchable on their own. I'm trying to figure out how to create the file in the Document library with the multi-choice Category field populated. The closest I've seen requires Patching an existing file as opposed to simply creating it from scratch. Any thoughts?

Was this reply helpful? Yes No
WarrenBelz 156,384 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @LeeCarver ,
You are trying to update a table with another table?
The below might work putting comma separated values in the "first" item, but I think you will have difficultly doing this. Why are you simply not using the standard Choices([@ListName].FieldName) in the control and simply writing back ControlName.Selected?
Patch( Engagements ThisItem, { Category: { Value: Concat( CategoryBox.SelectedItems, Value & ", " ) } } )

Was this reply helpful? Yes No
LeeCarver 6 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz- Essentially, yes. Users are uploading new files to a document library. They tag the documents with metadata populated from the Choice column that exists in the document library already. They aren't adding any new tags - just selecting from the ones we've set in place to identify the documents. That said, the documents could have multiple tags. So we are pushing the Category ComboBox values from the form back to the SharePoint Document Library, which mirror one another.

I was not using the ControlName.Selected property as my understanding is this is only for a single selection. When I like a label in the form with ControlName.Selected.Value, it only populates one value.

The more I've been playing and reading about this, I feel like the solution is to create a two step process on the form: (1) have the user upload the file with minimal information, thus creating the file/record in the SharePoint Document Library and then (2) having the button switch to a new navigation page on the form where the form loads the individual record that was just created and updated/patch the existing record. Do you think that would be a viable solution? Right now, it just doesn't seem that Microsoft/PowerApps/SharePoint like to play nice when populating a Choice column field on a new record.

Was this reply helpful? Yes No