Power Platform Community Forum Thread Details

Hello,

I am facing an issue regarding a shopping cart app described in this video https://www.youtube.com/watch?v=Ztn39KuOW0g&t=1927s.

In my app version I'm proposing events tickets and I added the groupby function in order to select the date.

But here comes the issue when I would like to add the collection to a dataverse table, I receive the following error message:

"Network error using Collect function Field "xyz_Title" is required"

And within the code the error message: "The specified 'columnXYZ' does not exist the column with the most similar name in powerapps is 'columnXYZ' "

Here is the code:

Set(VarShowSpinner,true);
Set(Varcompletion,true);
Set(VarRecordID,Patch('Utilisateurs CSES',Defaults('Utilisateurs CSES'),{Noms:UtilisateurLabel.Text,
'Date Facture' : Today(), 'Total Facture':Sum(CSEcollect,'Sous Total')}).'ID facture');

Collect('Facture historique',AddColumns(CSEcollect, "FactureID", VarRecordID,"Noms",Label2_2.Text,"DateFacture", Today()));

UpdateIf('CSE Démo tables','ID Ticket'= Gallery3.Selected.'ID ticket',{'Quantité en stock':'Quantité en stock'-Slider1.Value,'Quantité achetée':'Quantité achetée'+ Slider1.Value});

Clear(CSEcollect);

I know a similar subject was created in 2021 but without an answer.

Could you please help out ?

Thank you,

Corentin

Categories:

Building Power Apps

It could be an old name of a column that was renamed. This happened to me and I found it through a flow in Power Automate. I ran a getitems sharepoint call and in the output noticed that the column name it has listed in the json was the old name and not the new name. You could check by doing the same thing.

make a simple 1-step flow in power automate with the only step being grabbing the items from you data source. when you run it just click download output and use ctrl-f to find the value for the column that is in question. If the json shows a different column name than you expect as the column for that value then just change to that name in your app and see if that fixes it. This fixed the issue for me last week after 30 min of messing about confused.