Sharepoint list Error names

[JoaoN]

Hello Guys.

I am changing my data source from Excel to Sharepoint List. I am having a lot of issue doing that.
1- One of my columns have decimal number (0,1; 0,2 etc). When I try to import (From Sharepoint), this column is imported as integer (1; 2 etc);

2- My app shows an error from 2 column in "ThisItem" function and when I try to Collect data to the data source. I notice, clicking on the data source expression, that 2 column was writen wrong by PowerApps (Sharepoint list is ok).

The first picture shows the collect error (N10 is different of N10???)

 The second picture shows a test that I have made creating a gallery using the same data source, and using the "Thisitem.N10" function and it is working ok, but at table information you can see that "OData_..." error. (Should be N10 and ZN10 in that 2 column)

In this third picture, I have a gallery with the same data source (FUROS) but the "Thisitem.N10" is not recognized.

I am really confused with this. Anyone have an idea of what is happening?

Thank you

 

 

[WarrenBelz]

Hi @JoaoN ,

Did you have headings on the Excel file when you imported and did you format as a table beforehand (what did the Excel sheet look like before importing)?

Also what does you SharePoint List settings look like in the field names?

[JoaoN]

Hello @WarrenBelz . At Excel, yes I have format it as table (I was already using it as data source in Powerapps for a while), and I have headings as you can see in the next picture

At Sharepoint list, I made it as in excel table (In this case I gave up trying to import and made it from scratch). Here you can see the SPL heading

 

[WarrenBelz]

Hi @JoaoN ,

Your images are too small for me to read the code - can you please save them as images and then add using the camera icon. Also can you please also post the code as Text. After you re-created in SharePoint, are you still getting the errors? If so, what are the Items of your Gallery?

[JoaoN]

@WarrenBelzSorry! Sure I am uploading now.
The code in the next image (in the Onselect):

UpdateContext({varLoadingSync:true});

If(IsBlank(LookUp(FUROS, Campanha = gal_Campanha_Sync.Selected.Result && Furo = L_Furo_Sync_gal.Text)),Collect(FUROS,DropColumns(Filter(OffFuro,Campanha = gal_Campanha_Sync.Selected.Result && Furo = L_Furo_Sync_gal.Text),"varProf")));

Notify("Furo " & ThisItem.Result & " sincronizado com sucesso!",NotificationType.Success);

UpdateContext({varLoadingSync:false})

Gallery Item:

Distinct(Filter(OffFuro,gal_Campanha_Sync.Selected.Result = Campanha),Furo)

The collect button:

Collect(
    OffFuro,
    {
        Campanha: Label_Campanha.Text,
        Furo: Label_Furo.Text,
        N10: TextInputGravar_N10.Text,
        ZN10: TextInputGravar_ZN10.Text,
        Z: LabelGravar_varProf.Text,
        Tmax: TextInputGravar_Tmax.Text,
        Tres: TextInputGravar_Tres.Text,
        Obs: TextInput_Obs.Text,
        varProf: varProf,
        Horario: varHoraregistro
    }
)

Other image from the my first post:

[WarrenBelz]

Hi @JoaoN ,

What is varProf ?

UpdateContext({varLoadingSync:true});
If(
   !IsBlank(
      LookUp(
         FUROS, 
         Campanha = gal_Campanha_Sync.Selected.Result && 
         Furo = L_Furo_Sync_gal.Text
      ).Title
   ),
   Collect(
      FUROS,
         DropColumns(
            Filter(
               OffFuro,
               Campanha = gal_Campanha_Sync.Selected.Result && 
               Furo = L_Furo_Sync_gal.Text
            ),
            "N10"
         )
      )
   );
   Notify(
      "Furo " & ThisItem.Result & " sincronizado com sucesso!",
      NotificationType.Success
   );
   UpdateContext({varLoadingSync:false})
)

You cannot refer to a field name dynamically - you need to specify the actual column name you want to drop. Are you trying to drop "N10"?

You also seem to have the logic backwards as if the lookup is blank, there will be nothing to collect. 
Where is this run from (you are referring to ThisItem.Result)

As I mentioned, if you are still having issue with your field names, have a look in the SharePoint list settings and select one, then look at the end of the string at top and you will see the actual (original) name.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[JoaoN]

Hi @WarrenBelz .
varProf is a variable that I use to increment a depth value (varProf = varProf +0,1) every time I tap the collect button.
Actually I have to consider N10 and ZN10 in the Collect function (to upload data to Sharepoint). The column I am not interested is "varProf".

I did as you mentioned and notice now that the name of my Column at Sharepoint list setting is wrong (in the URL), but is ok at "Column name"


The ThisItem.Result is because I have another gallery that just shows the ID of each test that I have collected (there are many rows per test). So I use the distinct function in this another Gallery and when I click in one item, it filter the Gallery that I show to you. There is a picture of how it works:


In the left Gallery (gal_Campanha_Sync) I select the "Campanha" that is my ID.
Gallery in the right is filtered by this ID and shows me each test I made to the same ID.

[WarrenBelz]

Hi @JoaoN ,
As I mentioned, you cannot refer to field names dynamically, so varProf simply will not work in DropColumns() - you have to refer to the column name.

Also your N10 field name is actually _x004e_10 . Strangely ASCII 4E is N,

but for some reason, it is named that way on the Excel import (so you will have to refer to it like that).
Also ThisItem will only work if you are running the code from inside a Gallery or inside a card on a Form.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[JoaoN]

I did the import from Excel firstly but I gave up trying to do this. So I made the List in Sharepoint from the beginning.
The other configuration is working fine (actually it was already working ok when I was using Excel table). The "Thisitem" is being used in the same gallery. When I refer to another gallery I use the "GalleryXX.selected". Anyway, I will try to remove the "varProf" from the expression, but it is not getting error from it.

My issue now is that this 2 column (N10 and ZN10) are getting this strange name when I create it at SPL. I tried to reset the original language of SPl, tried to use the classic version, create column in the List Settings and in the list grid. Nothing is working.
If I create a column named "N", it is ok but "N10" is always getting that error.

[WarrenBelz · Accepted solution]

@JoaoN ,

Sounds like a bug of some sort - there is an issue with naming when you put a number at the start of the field, but I have not seen this one before - you might try N_10 (you will have to delete the old field and add a new one).

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.