Power Platform Community Forum Thread Details

Hello,

My goal is to create a collection in order to retrieve it via a JSON function to export the data entered in an Excel table.

Here is what my application looks like:

I want to retrieve all the rows "N°Fiche", "Type de tâche", "Type de vehicule", "Nom du client", "Temps"...

So I have created a button where for the moment I have this formula that does not show me any error:

ClearCollect(
List;
{
Tache11: Tache1.Selected.Value;
Tache12: Tache2.Selected.Value;
Tache13: Tache3.Selected.Value;
Tache14: Tache4.Selected.Value;
Tache15: Tache5.Selected.Value;
Tache16: Tache6.Selected.Value;
Tache17: Tache7.Selected.Value;
Tache18: Tache8.Selected.Value;
Tache19: Tache9.Selected.Value;
Tache20: Tache10.Selected.Value;
Vehcule11: Vehicule1.Selected.Value;
Vehcule12: Vehicule2.Selected.Value;
Vehcule13: Vehicule3.Selected.Value;
Vehcule14: Vehicule4.Selected.Value;
Vehcule15: Vehicule5.Selected.Value;
Vehcule16: Vehicule6.Selected.Value;
Vehcule17: Vehicule7.Selected.Value;
Vehcule18: Vehicule8.Selected.Value;
Vehcule19: Vehicule9.Selected.Value;
Vehcule20: Vehicule10.Selected.Value;
Temps11: Temps1.Text;
Temps12: Temps2.Text;
Temps13: Temps3.Text;
Temps14: Temps4.Text;
Temps15: Temps5.Text;
Temps16: Temps6.Text;
Temps17: Temps7.Text;
Temps18: Temps8.Text;
Temps19: Temps9.Text;
Temps20: Temps10.Text;
TempsTotal1: TempsTotal.Text
}
)

However, this formula system does not work on drop down lists that fetch their data from Excel tables in my Onedrive, so it doesn't work with ""N°Fiche"", "Nom du client". I have the following error :