Answered

Patch Function Not Showing All Items Chosen

(0) Share

Report

Posted on by Phineas

5,331 Moderator

Below I have provided the components from a Gallery, Combo Box, and SP List.
The top portion of the formula is working; However, I cannot get all of the items
chosen in the Combo Box to update into the SP List - Progress_items column.

Only one item, the last one chosen, shows rather than the three chosen.

What am I missing?

Patch Formula -

If(Client_Detail_Client_ID_Fld.Text=ThisItem.ClientID,
Patch(Client_Data_List,LookUp(Client_Data_List,ClientID=Client_Detail_Client_ID_Fld.Text),
{Progress_Count: Label3_1.Text}));

If(Client_Detail_Client_ID_Fld.Text=ThisItem.ClientID,
Patch(Client_Data_List,LookUp(Client_Data_List,ClientID=Client_Detail_Client_ID_Fld.Text),
{Progress_Items: ComboBox1.Selected.Value}));

Combo Box Control -

Slider Control -

SharePoint List Columns -

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Sort by

TheRobRush 11,128 Moderator on at

Like (0)

Report
Copy link

Link copied!
Is progress_items a choice column? If so should be something like

{Progress_Items:ForAll(ComboBox1.SelectedItems As choicesMade, {Value: choicesMade.Title /*(.Title may be .something else like .Value, .Name etc depending on source of combobox*/})}

if its a single line of text column will need to use a concat with ComboBox1.SelectedItems for example

Concat(ComboBox1.SelectedItems, Title, "; ")

Was this reply helpful? Yes No
Phineas 5,331 Moderator on at

Like (0)

Report
Copy link

Link copied!

I tried the recommended formula. I probably crafted it wrong, as it is not working, even though no errors are thrown.
If(Client_Detail_Client_ID_Fld.Text=ThisItem.ClientID,
Patch(Client_Data_List,LookUp(Client_Data_List,ClientID=Client_Detail_Client_ID_Fld.Text),
{Progress_Items: Concat(ComboBox1.SelectedItems, "; ")})))

Also, when I try to return the items to the Gallery Combo Box (with ThisItem.Progress_Items)
I get the error 'Expected Table Value'. The SP List column is 'single line of text'.

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like (0)

Report
Copy link

Link copied!
Yah so, I don't really know what your if statement is based on so cant say much about it, way you wrong though needs the column selecgtion

Concat(ComboBox1.SelectedItems, Title, "; ")

in that example Title is my column name

to display this info in a combo box later you would need to split it as combo boxes display tables, not text so that would be liek this

Split(ThisItem.Progress_Items, ";") /* Or "; " if you include the space in the ocncat earlier */

Was this reply helpful? Yes No
Phineas 5,331 Moderator on at

Like (0)

Report
Copy link

Link copied!

I tried it with the column name and PA is giving me the error -
'Name isn't valid. Progress_items isn't recognized'.

The split DID return the one item that is being updated to the SP List.
Split(ThisItem.Progress_Items, "; ")

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like (0)

Report
Copy link

Link copied!

ou need to go to your list settings, and click that column then look at top addrss bar where you will find the proper name to refer to it by in powerapps it likely got changed at some point

portion AFTER the = is the name to refer to it by

Was this reply helpful? Yes No
Phineas 5,331 Moderator on at

Like (0)

Report
Copy link

Link copied!

Yep, I provided that in the previous post.

Here it is again - name is 'Progress_Items', as written in the formula.

Was this reply helpful? Yes No
Verified answer

TheRobRush 11,128 Moderator on at

Like (1)

Report
Copy link

Link copied!

what is in the items property of your combo box? if you are including Progress_Items in your concat then the combobox items has to be a table that includes that column, it not having that column would be only way you would get that error. the second part of that concat should be which column of your combo box you want to return. So if your combobox items is just something like ["Option 1", "Option 2", "Option 3"] the formula would read Concat(ComboBox1.SelectedItems, Value, "; ")

Was this reply helpful? Yes No
TheRobRush 11,128 Moderator on at

Like (0)

Report
Copy link

Link copied!

Concat combines multiple rows of a single column in a table (not adding multiple text sources from different sources)

Was this reply helpful? Yes No
Phineas 5,331 Moderator on at

Like (1)

Report
Copy link

Link copied!

Eureka!
If(Client_Detail_Client_ID_Fld.Text=ThisItem.ClientID,
Patch(Client_Data_List,LookUp(Client_Data_List,ClientID=Client_Detail_Client_ID_Fld.Text),
{Progress_Items: Concat(ComboBox1.SelectedItems, Value, "; ")}))

That's the ticket to ride!

Was this reply helpful? Yes No