Multi select choice column with custom text

(0) Share

Report

Posted on by WackdeMack

197

Hi all,

I have a very simple question. I have a multi selected choice column and want to use custom text input.

The problem, i can input a custom text but not combine with the standard values.

If(Not IsBlank(DataCardValue6.SelectedItems); DataCardValue6.SelectedItems;{Value: DataCardValue6.SearchText; '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"})

I'm sure my code is fine. I can fill in one custom text value but can't combine it with my standard values.

Here is my source for the code https://powerusers.microsoft.com/t5/Power-Apps-Ideas/SharePoint-Choice-Fill-in-option/idi-p/83218#comments

Doenst anyone has the solution?

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

JayMagness 1,663 on at

Like (1)

Report
Copy link

Link copied!

Hi,

I personally do things like this in SharePoint. I create a calculated field in the SharePoint table and do all field combinations there.

Here is an example of a SharePoint calculation that renders the year in different order to help with unique codes every time off the created field.

=RIGHT(YEAR(Created),2)&"0"&(MONTH(Created))&"0"&(DAY(Created))

If you want you can contact me also jay@research-nest.com

Was this reply helpful? Yes No
v-siky-msft Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!
Hi @WackdeMack ,

Please try this:

Modify the Submit button. OnSelect property:

ClearCollect(Col1,DataCardValue6.SelectedItems,{Value:DataCardValue6.SearchText}); ClearCollect(Col2,AddColumns(Col1,"'@odata.type'","#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference")); SubmitForm(FormName)

Modify the Update property:

If(IsBlank(First(DataCardValue6.SelectedItems).Value);Table({Value: DataCardValue6.SearchText; '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"}); Col2)

Hope this helps.

Sik

Was this reply helpful? Yes No
WackdeMack 197 on at

Like (0)

Report
Copy link

Link copied!
I use a PowerApp Form instead of an app but i can make an Submit button 🙂
After the first line, my code doenst work anymore, the first line looks fine:

ClearCollect(Col1;DataCardValue6.SelectedItems;{Value: DataCardValue6.SearchText});
But after this, PowerApps doenst work anymore, this is the code:
ClearCollect(Col1,DataCardValue6.SelectedItems,{Value:DataCardValue6.SearchText}); ClearCollect(Col2,AddColumns(Col1,"'@odata.type'","#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference")); SubmitForm(FormName)

Was this reply helpful? Yes No
Verified answer

v-siky-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @WackdeMack ,

The codes works well on my side.

Could you please try this? I found the Col2 is not necessary.

1. Modify the OnSave property:

ClearCollect(MyCol;DataCardValue6.SelectedItems;{Value:DataCardValue6.SearchText});; SubmitForm(FormName)

2. Modify the Update property:

If(IsBlank(First(DataCardValue6.SelectedItems).Value);Table({Value: DataCardValue6.SearchText; '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"}); MyCol)

Hope this helps.
Sik

Was this reply helpful? Yes No
WackdeMack 197 on at

Like (1)

Report
Copy link

Link copied!
Hi @v-siky-msft

I have a very strange error with the solution. When i fill in my PowerApp Form, i get an error when i just select of of my choice. I can click again, and then the item is save. When i just use a custom value, i got no error, doest that make sense?
Can you reproduce this?
Onsave:

ClearCollect( MyCol; DataCardValue6.SelectedItems; {Value: DataCardValue6.SearchText} );; SubmitForm(SharePointForm1)

Update:

If( IsBlank(First(DataCardValue6.SelectedItems).Value); Table( { Value: DataCardValue6.SearchText; '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference" } ); MyCol )

Edit: Fixed with, the column was required in SharePoint. I changed that and now is everything is fine.

Was this reply helpful? Yes No
Voltron 67 on at

Like (0)

Report
Copy link

Link copied!

hi! similar problem Please explain which column you are talking about. I get an error after a time. I can't figure out what the reason is.

Was this reply helpful? Yes No
Voltron 67 on at

Like (0)

Report
Copy link

Link copied!
why creating a collection generates an empty field.
this formula creates an empty value and an error occurs
ClearCollect( MyCol; DataCardValue6.SelectedItems; {Value: DataCardValue6.SearchText} );; SubmitForm(SharePointForm1)

Was this reply helpful? Yes No
Voltron 67 on at

Like (0)

Report
Copy link

Link copied!

could you tell me?

Was this reply helpful? Yes No
Voltron 67 on at

Like (0)

Report
Copy link

Link copied!

if it would be useful for someone to add filtering to exclude empty values in the collection

Was this reply helpful? Yes No