Showing results for 
Search instead for 
Did you mean: 
Level 10

User Added Items Added to Search

What are some ideas for this scenario? 


  • User adds comma separated "tags" to Textbox
  • Values are added to a Collection via something like: 


  • User clicks "Submit" button
  • Somehow the Collection "tags" is Patched to a field in an Azure table
  • Next time user visits app, all tags (suggestions) from the Azure table are shown AS THE USER TYPES
    • Similar to the "Search" when creating a new messege in this forum
  • When user types a comma, the tag suggestions disappear until typing of next tag. This repeats until user enters last tag and clicks "Submit" button again. 
  • User can click one of the tags displayed to add it to the Textbox

The goal here is to crowd source tags (similar to how the forum software HERE does it), get consistent tags for word-clouds, etc. 


I dont' know: 

  1. What the data source would be set to for Textbox (somehow all the tags previously submitted would need to be de-duplicated and added to a Collection OnStart)
  2. How to Patch a Collection to a single Azure field (i have the db setup, just haven't tried this type of Patch yet)
  3. How to search and match tags in real time, based on what the user is typing (I wonder if this is even possible in PA!)





Community Support Team
Community Support Team

Re: User Added Items Added to Search

1.If you only want to add Distinct value, then the clearcollect function should be:


2. To store the data into Azure table single field, try:

forall(tags, patch(AzureTable, defaults(AzureTable),{FieldName:Result}))

3. To search with the existing one, you could consider take use of Combo Box control.


Currently PowerApps control don't support "fill-in choices", so the tag experiences can't be fully supported with PowerApps, based on what I know.




Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.