Power Platform Community Forum Thread Details

Hi everyone,

I am currently building a registration tool for a day event with Microsoft PowerApps. I have a form for this in which the speaker should enter information about themselves and the presentation. Everything is saved via Submit (Form1) to a Sharepoint List.

Among other things, there is a drop-down list with different times/numbers (10, 11, 13, 14, 15) that can be selected for the starting time of their speak.

I only want to see the times that are stored three times or less in my sharepoint list in the dropdown list.

I have created collections for this purpose.

ClearCollect(

allZeitslots;

Choices([@'UX Day 2024 Liste von Sessions'].Zeitslot)

);;

ClearCollect(

col_Zeitslot_Häufigkeit;

{

Zeitslot: "10";

Häufigkeit: CountRows(Filter('UX Day 2024 Liste von Sessions'; Zeitslot.Value = "10"))

};

{

Zeitslot: "11";

Häufigkeit: CountRows(Filter('UX Day 2024 Liste von Sessions';Zeitslot.Value = 11))

};

{

Zeitslot: "13";

Häufigkeit: CountRows(Filter('UX Day 2024 Liste von Sessions'; Zeitslot.Value = "13"))

};

{

Zeitslot: "14";

Häufigkeit: CountRows(Filter('UX Day 2024 Liste von Sessions'; Zeitslot.Value = "14"))

};

{

Zeitslot: "15";

Häufigkeit: CountRows(Filter('UX Day 2024 Liste von Sessions'; Zeitslot.Value = "15"))

}

);;

ClearCollect(

col_FilteredZeitslots;

Filter(col_Zeitslot_Häufigkeit; Häufigkeit < 2).Zeitslot

);;

col_FilteredZeitslots also returns the correct list. So I set the "Items" from my drop-down list to the variable col_FilteredZeitslots.

However, I now have the problem that the collection is set as the data source for my dropdown list and no longer my Sharepoint list, which is why the selected time of the dropdown is no longer saved in the Sharepoint list.

Could you please help me with this. 😊

Categories:

Building Power Apps