Form Edit, Cascading Dropdown (

(0) Share

Report

Posted on by Chris_tatzber

Hello,

i have a problem with my edit_form and the cascading datacards.

I have a sharepoint list. (>2000 values) and I want to read out several coloumns, which should be checked and updated if necessary.

Through the app the colomn GPS lat + longtitude, Schicht, a picture of the equipments should be saved to the dataset. The sharepoint list is posted below:

So I created a edit form in power apps. The main field is the Title field through this I want to edit via cascading comboboxes the other values of the list.

It should be like this: When the user chooses a Equipment. LO/LC combobox and R&I combobox values should be loaded from the sharepoint list.

I tried for the cascading combobox already several methods but it isn't working. I got the failure because of different types and because of exceeding 2000 items in the list. So I load the list into a collection at the beginning.

When everything is collected I want to replace the existing data from the sharepoint list with the data collected / updated in this app.

Tried already:

In datacard update field I tried:

'cbR&I'.Selected.'R&I'

Do you have an Idea how to solve this problem?

Best Regards

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report
Hi @Chris_tatzber.,

Do you want to populate the LO/LC combo box and R&I combo box based on the Title selected?

Could you please tell me how you configure the Equipment Combo Box Items property?

I assume that you have already create a collection to save all the items within and you populate the Equipment Combo Box Items property with the Title column from the collection, right?

Based on this, I think you should try the following steps:

1). Create a Collection as below:

ClearCollect(colList,ListName)

2). Set the Equipment Combo Box Items property as below:

colList.Title

Set the Update property of the data card corresponding to the Equipment as below:

ComboBox_Equipment.Selected.Title

3). Set the LO/LC Combo Box Items property as below:

Filter(colList,Title=Equipment_ComboBox.Selected.Title).'LO/LC'

Set the Update property of the data card corresponding to the LO/LC as below:

ComboBox_LO/LC.Selected.'LO/LC'

4). Set the R&I Combo Box Items property as below:

Filter(colList,Title=Equipment_ComboBox.Selected.Title,'LO/LC'=LO/LC_ComboBox.Selected.'LO/LC').'R&I'

Set the Update property of the data card corresponding to the R&I as below:

ComboBox_R&I.Selected.'R&I'

Was this reply helpful? Yes No
Chris_tatzber 7 on at

Like (0)

Report

Perfect thank you Qi, it is working as it should know.

Two small problems still existing:
1) I load the list onVisible of the screen but it is not working - when I use a button to load it - it works.
2) Is it possible to write the filtered values of the comboboxes LO/LC and R&I when I select an equipment? Do I have to implement this in the update function?

Big thanks for your help - it makes a lot of fun.

Best Regards

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (1)

Report

Hi @Chris_tatzber,

Morning😊

1). The OnVisible property only works when you navigate to the screen where has a form within from another screen. So once you set the OnVisible property, you should exit from the current screen and navigate to the destination screen one more time, that's how the OnVisible property works.

2). I am confused with this question, the comboboxes LO/LC and R&I do display the filtered values when you select an equipment. To write this back to SP list, you just need to reference to ComboBox.Selected.'LO/LC' or ComboBox.Selected.'R&I'

Was this reply helpful? Yes No
Chris_tatzber 7 on at

Like (0)

Report
Hello,
I have another Problem with the size of the items in the SP list. Everything worked fine, till I tested the search function in the combobox, because it does not search all the 5000 elements in the SP list.

For this I genereted a collection, which loads all elements in three collection; I merged them together and then search out of them.

The main goal would to search in the combobox for the items based on the first 3 characters. So when I enter 416 it should list all elements in the combobox from the SP List which starts with 416.

I created a textbox txtSearch which should be used to enter the first 3 characters, based on that, the combobox items should be filtered out of the merged collection.

The formulas which I used to update the lists:
onVisible (Screen):
ResetForm(Kettenschieber_Form);
Concurrent(
ClearCollect(col1, Filter('Kettenschieber LO/LC', ID >= 1 && ID <= 2000)),
ClearCollect(col2, Filter('Kettenschieber LO/LC', ID >= 2001 && ID <= 4000)),
ClearCollect(col3, Filter('Kettenschieber LO/LC', ID >= 4001 && ID <= 6000))
);
ClearCollect(MergedCollection, col1, col2,col3)

the formular for the items of the combobox Equipment:
Filter(MergedCollection,txtSearch.Text in MergedCollection.Title)

I now enter three characters in the textbox and the combobox items should be update out of that action. Do I have to do a update transaction on textbox change?

I also tried the following:
OnChange at the txtSearch field:
Set(varTitle, Filter(MergedCollection,txtSearch.Text in MergedCollection.Title));

Item at cbEquipment:
varTitle

Best Regards
Christoph

Was this reply helpful? Yes No