cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
FelipeCaru
Advocate V
Advocate V

Edit view / add field: Select or add new one

Hello all,

I have yet another question that I am not sure if it is possible to do or not.

In my edit screen, which I can see from either Detail>Edit entry or by adding a new entry, I want to be able to have the option to either write a new "title" or selecting from one already created. I know it sounds confusing, maybe, so, in images.

view1_forum.png

In my entry view, I have a list of projects to choose from, and shows the task I have yet to do. Keep in mind that project list. Now,

view2_forum.png

This is edit/new entry view. In this one, on the data that is on the red square, I have to add to what "project" it belongs, or type a new one if it is, well, new. So what I want to know is if it is possible to there choose from one that already exists from list or write new one, if needed; or perhaps write project name and give suggestions of name that already exists; if it doesn't exist, say "no match" in the suggestion field.

So:

  • Select "title"/project from list or write new one
  • Select "title"/project from suggested list when typing or write new one

 

Thanks in advance,

21 REPLIES 21

@FelipeCaru 

You'll need to always adjust your Formulas based on your own app names.  If I've put "dataSource" in a formula, that's just a representation that this is where you put YOUR datasource.  It appears from your photos, that it is called demo_project

I am also assuming now that your DataCardValue1_1 has been deleted and you are now working with DataCardValue18.

 

So, from what I see, your formula should be:

   RenameColumns(Distinct(demo_project; Title); "Result"; "Value")

 

The Update formula error should go away once the above is corrected.

 

Let's see if we get you there in this one...

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

Whoops @RandyHayes was confused since there was in the default one one called with "info" 😛

Also, nooope, not yet. Altough, now I could be forced to choose one:

errorComboBox3.png

 

Not sure what I am doing wrong tbh.

 

As additional info:

errorComboBox3MasInfo.png

@FelipeCaru 

Double check your properties on the DataCardValue18 combobox control.

 

Make sure you have the following:

   Allow Multiple Selections to Off

   Allow Searching to On

   Items to Parent.AllowedValues

   Default to  {Value:ThisItem.Title}

   InputTextPlaceHolder to whatever you want the hint text to be.

   DisplayFields and SearchFields to ["Value"]

 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

"Search" had slipped by and was off, turned it on, and also added that default value @RandyHayes .

I now have:

errorCombobox4.png

Which allows me to write one and keep it, however, the list to search only shows "Title"

@FelipeCaru 

Perhaps good for a laugh to conclude this for you...

I didn't notice it before, but you have quotes around Title in your distinct statment (RenameColumns(Distinct(demo_project;"Title");"Result";"Value") ) so guess what...you're only going to have "Title" in your results Smiley LOL

 

So, change your AllowedValues to:

  RenameColumns(Distinct(demo_project;Title);"Result";"Value")

 

And you *should* be good.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

Not sure if you or I should cackle and yell "IT WORKS" (instead of the classic it's alive), since, well, it works 😄

 

Thank you!
Seems I'll have to mark some many answers as solution @RandyHayes 

@FelipeCaruAlways good to hit the end goal! Smiley LOL

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

@RandyHayes 

Sorry to bother(?) you yet again.

Regarding the combobox, I have no problem adding a new one, however, when editing one, it says the error of "requiring an entry or has a not valid value. Correct and try again" (I think it's the default error on it).

 

What can I do?

@FelipeCaru 

Throw a screenshot this way so I can see more specific what you are seeing.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

@RandyHayes 

Posting now a "step by step" of how I get the error, so to speak.

forumEdicion1.png

forumEdicion2.png

forumEdicion3.png

forumEdicion4.png

 

I go to the detail view, then go edit, then select one option and when trying to change that, says error there.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Top Solution Authors
Users online (3,005)