cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Etienne79
Frequent Visitor

Datacard control value depending on another dropdown control

Hi there and thanks ahead to read/help me,

 

my case is the following :

I have 2 Sharepoint lists :

[Owners] with ID (automatically set) and OWNER_NAME (text)

[Homes] with ID (automatically set) and OWNER_ID (numerical) fields

In order to avoid mistakes, [@HOME].OWNER_ID is linked (through lookup in Sharepoint) with [@OWNERS].ID

 

In the form edit/new for [HOMES], I'd like to get the dropdown of OWNER_NAMES instead of OWNER_ID (or some trick so).

Before arriving here, I searched (not enough it seems 🙂 ) :

- control dependant of

- input.text with value

- filter / loopkup in Items, DisplayFields

Now, I'm lost...

I succeeded by adding a field "OWNER_ID" in [OWNERS] and setting the value of ID in it but this is not what I was aiming to...

Is the problem related with the use of ID ? any restrictions with links between Sharepoint lists ?

 

Thanks for taking me out of this 3 days nightmare !

Etienne, humble PowerApps beginner but already convinced !

 

1 ACCEPTED SOLUTION

Accepted Solutions

@Etienne79 

So if that column is a SharePoint lookup column, then change the Update property of your datacard to the following:

{
    Value: Dropdown_Owners.Selected.OWNER_NAME,
    Id: Dropdown_Owners.Selected.ID,
    '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"
}

This is assuming again that you have a lookup column.

Let's see if that moves you forward.

_____________________________________________________________________________________
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!

View solution in original post

9 REPLIES 9
RandyHayes
Super User
Super User

@Etienne79 

Welcome to PowerApps!  Sit back and enjoy the ride.  

 

What? You say you hit a bump?  Okay, let's explore.  You mentioned that you want the DropDown to have the Owner Name in it.  Do you want ALL of the Owner Names from your Owners list?  If so, then you can set the Items property of your DropDown to the following:  Owners

Make sure then (in the properties pane of the designer) that you select the OWNER_NAME to display.

 

I hope this is helpful for you.  If you wanted something besides all the names, just let me know.

_____________________________________________________________________________________
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!

Thanks for the ride, I’m in !

I tried your proposal but, beside there’s no more error message, it’s still not working, the field is not update.

in parallel, I created a simple form with classical dropdowns based on values (as automatically designed) and field updates works. It shows that the problem is still existing... I have the impresssion it’s because of dealing with the ID field of the lists...

@Etienne79 

Can you perhaps share a screen shot or two of what you are seeing?

Originally I was addressing just your plan to have the Owner Names in the dropdown - did we get that working?

Now, as I understand it, you have an Edit for with this DropDown and when you submit the form, you are not getting what you expect in the record created?

_____________________________________________________________________________________
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!

Thanks @RandyHayes ,

 

here's my view (simplified) :

Etienne79_0-1597305226592.png

in for Form, I'd like to replace the Owner_ID dropdown of DataCard by the "Dropdown_Owners" of names and take the value into account in the form.

I changed "Update" of the DataCard : nok, as you can see for House5 entry : the entry has been added but no OWNER_ID...

 

Thanks for help,

I'll switch to Patch function (more risky and painfull) if no solution...

 

Etienne

@RandyHayes 

This is not yet THE solution but... a bit progress on my side :

Etienne79_2-1597322719556.png

 

I filter the DataCard_Control of OWNER_ID with the formulas including "Id" for both "Items" and "DefaultSelectedItems".

Thus, I can add my DropDown_Owners button and hide the DataCard_Control.

 

My wish, purer, was to keep only one control or use the DataCard_Control to display directly the OWNERS_NAMES instead of going tricky like this.

If you (all) get better solution, please reply !

 

Thanks

@Etienne79 

So if that column is a SharePoint lookup column, then change the Update property of your datacard to the following:

{
    Value: Dropdown_Owners.Selected.OWNER_NAME,
    Id: Dropdown_Owners.Selected.ID,
    '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"
}

This is assuming again that you have a lookup column.

Let's see if that moves you forward.

_____________________________________________________________________________________
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!

Works perfectly ! Many thanks @RandyHayes although the solution seems to me a bit dark!

I confirmed it worked even by deleting the control of DataCard keeping only the DropDown_Owners button ! Exactly what I wanted !

 

How could I've guessed / found out from references the '@odata' line ?

Aim is to "force" the data when updating the DataCard ?


Thanks,

Etienne

@Etienne79 

It's because of the complex column type you are using.  Keep it in mind - any time you are trying to alter a Choice column, a Person Column, or a Lookup Column, you need to give it this special attention.

If you use an EditForm out of the box, it will account for it for you automatically.  However, in your case, you are actually trying to derive your true value from someplace else (the Dropdown).  So you have one of two choices, get your Dropdown items to have that exact field "signature", or just force it in the Update property.  I usually opt for the second.

 

Yes, it is a bit obscure.  There is an article on getting your Dropdown with the correct signature here.  You'll find example of all the signatures for the three complex types and patching them (which would also indirectly apply to using the Update property of your datacard) here.

Plus, if you search this forum, you'll find many references to it.

But yes, it's not something that you "just know"...you "just learn".

_____________________________________________________________________________________
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!

Thanks again @RandyHayes for not ony your solution but for the explanation of it !

It clearly highlighted me !

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,508)