Use Checkbox to set value instead of DropDown

[Frankie70]

Hello all,

I have a DrowDown1 connected to a Datasource (SharePoint List).

The user should be able to check a CheckBox1 and when sending the form, instead of a value from the DropDown1, there should be "CheckboxValue" used (in the same coumn of the SharePoint list.

So far, I use OnCheck=Dropdown1Value.Selected.Value="CheckboxValue".

But it simply does not work and gives me an error when sending the form.

"An entry is required or has an invalid value. Please correct and try again."

Can anybody help?

[RandyHayes]

@Frankie70 

Your formula for the DefaultSelectedItems is not going to work in this way.  You need to reference the column that has the title in it for the lookup, not the DataCard.

You had said that you created a column in your list which is a "Single Line of Text" where you are storing the selected value (the Title) from the other list (LegalEntitiesOrga).  That is the field you need to reference in your formula.  

I don't know what you called that column in your list, so I am going to call it LegalEntity for this moment.

And...Your formula should be:

Lookup(LegalEntitiesOrga, Title=ThisItem.LegalEntity)

Obviously, replace the LegalEntity column name with the one you created in your list.

You've got a lot of other red X's on that screen shot...what's going on with them?

[Frankie70]

@RandyHayes 

Thanks a lot, but unfortunately this does not work.

PowerApps does not seem to accept "ThisItem". I attached a Screenshot.

The other red X's are gone 🙂

[RandyHayes]

@Frankie70 

Is your ComboBox in the Form? Or is this outside of a Form?  I had assumed you were in a form - where "ThisItem" is a valid option.

Also, is "Ensured Entity" the actual name of your column in the data source?

[Frankie70]

@RandyHayes 

The ComboBox is outside the form. I inserted it manually via PowerApps.

Yes, "Insured Entity" is the actual name of the column in the data source.

[RandyHayes]

@Frankie70 

Based on the scenario of what you are trying to do, you might be better served if you put in a custom datacard for your form and put that combo box in there.  That way you will have the ability to interact more easily with the current record in the form.

Otherwise, you will have to reference the same record that the item property of the form has.

So, Lookup(LegalEntitiesOrga, Title=Lookup(yourFormDataSource, whateverYourItemPropertyOfTheFormIs).LegalEntity)

Although the above will work, you might find yourself with issues on new forms or other situations.  If you include the ComboBox in a custom data card in your form, you can interact with the current record easier and you will not have to reference outside of that form as we do above.

[Frankie70]

@RandyHayes 

Sorry for not reacting on your comment. I was on holidays.

For a start, I would like to use your suggested formula:

Lookup(LegalEntitiesOrga, Title=Lookup(yourFormDataSource, whateverYourItemPropertyOfTheFormIs).LegalEntity)

Somehow, these two values will not work:

yourFormDataSource, whateverYourItemPropertyOfTheFormIs

yourFormDataSource: is this the name of my SharePoint List?

whateverYourItemPropertyOfTheFormIs: is this the name of the column (Insured Entity) of my SharePoint list?

[RandyHayes]

@Frankie70 

I hope you had a good holiday!  Welcome back...

I'd still advise on the custom datacard for this scenario, but, if going the other route...

Yes, the yourFormDataSource is your SharePoint list.  Look at your Form and see what its datasource is set to.  That is what you want.

whateverYourItemPropertyOfTheFormIs - Look at the Item Property on your Form.  You would need to craft your lookup based on whatever the item property is getting for the form.  In general you want to have the lookup return the same record as the form item  is using.

If unsure, post your formula for the Item property and we can look at that.

Again, this would be easier if just a custom datacard in the Form.  From looking at the screen shot of the app, I believe it would work well from within the form.

[Frankie70]

@RandyHayes 

Thanks for your reply.

I am quite confused now.

Maybe you can have a look at this? I attached a screenshot. Hope this helps.

If you need anything else, please let me know!

[RandyHayes]

@Frankie70 

That formula is not going to give you much luck.

If you are pulling in all the records in your Items property for the ComboBox (LegalEntititesOrga), then you want to set this to the one in your current form record as the default.

So, ComboBox DefaultSelectedItems Property : Lookup(LegalEntitiesOrga, whateverYouAreUsingForYourFormItem)

Let me explain the above a little better...

I am assuming your DataSource for your form is Insurance and I don't know what your Item property is for your form (Perhaps share that info).  BUT, let's just say your Item property is SharePointIntegration.Selected  If that is the case, then your DefaultSelectedItems property on the ComboBox will be:

Lookup(LegalEntitiesOrga, Title=SharePointIntegration.Selected.'Insured Entity')

Here we are using the selected record (presumably what is in the form) to look up the record in the LegalEntitiesOrga list that has the Title equal to the current selected records' Insured Entity value.

[Frankie70]

@RandyHayes 

I am stuck on the Items Property you are mentioning.

See attached screenshot.

Thanks a lot for your help!