cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JoaoN
Helper IV
Helper IV

Sharepoint list Error names

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???)
Collect error.png

 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)

Collection names.PNG

 

 

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

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


Thank you

1 ACCEPTED SOLUTION

Accepted Solutions

@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.

View solution in original post

10 REPLIES 10
WarrenBelz
Super User III
Super User III

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?

 

 

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

JoaoN_0-1618203802226.png


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

SPL.PNG

 

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?

@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
    }
)


Collect error.png

Other image from the my first post:
Collection names.PNGN10 nao reconhecido.pngSPL.PNG

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.

 

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"
Wrong column name.PNG

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:

app.PNG
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.

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,

WarrenBelz_0-1618211723520.png

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.

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.

@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.

View solution in original post

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (2,961)