SharePoint PowerApps Allow Fill in Choices issue

(0) Share

Report

Posted on by SumanthDundi7

219

Hi,

I am using a SharePoint modern list with a Allow Fill In choice values option selected so that users can enter manual entries. I am using PowerApps connected to this list.

Problem is that, I don't want these manual entries to be shown as a choice values while filling the Form. I see these manual entries are getting stored somewhere and these manually entered choice values are showing up along with the actual choice values given to SP list choice column. My requirement is to show only the actual choice values not the manual entered ones. (Infact I have started working on App that someother team member who has built and rolled off from our company. I found this bug)

I am using following formula's

On Update Property of DataCard:

If( IsBlank(DataCardValue5_1.SearchText), DataCardValue5_1.Selected, If(DataCardValue5_1.SearchText in Choices('Employee Recognition Form'.Category).Value, DataCardValue5_1.Selected, {Value: DataCardValue5_1.SearchText}))

OnSelect Property of DataCardValue:

@mdevaney @WarrenBelz @eka24 @KrishnaV

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

WarrenBelz 154,797 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
@SumanthDundi7 ,
The problem I suspect is the Items of the drop-down, which are probably a Distinct filter of the list column, meaning that the "added" entries will of course be included. There are a number of solutions, including hard-coding the choices, but one you might consider fo ease of management is a "shadow" Choice field in your list with the values you want.
Your Items would then be
Choices([@ListName].ShadowFieldName)

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
WarrenBelz 154,797 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @SumanthDundi7 ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

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
SumanthDundi7 219 on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz ,

Thank you for the idea. It worked and more importantly there is an option "Allow Searching" which needs to be enabled in Power Apps to allow manual entries which I learnt.

Was this reply helpful? Yes No