Hello, I am using the SortByColumns function inside the "items" field of a gallery to sort my gallery by date (gallery created from a sharepoint list).
I got two date variables, same format (created using another app and putting same data in two variables whith Patch, 'Delai' and 'Delai_nouv').
Problem here is that :
SortByColumns('Informations demandes', "Delai", If(SortDescending1, Descending, Ascending))
is working, and that :
SortByColumns('Informations demandes', "Delai_nouv", If(SortDescending1, Descending, Ascending))
is creating the error :
The specified column 'Delai_nouv' does not exist.
whereas inside my gallery, ThisItem.Delai_nouv is working while using the same connexion to my sharepoint list.
I tried updating my list using View -> Data Sources.
I also tried deleting the connexion and recreating it.
I hope someone got a workaround cause i don't want to recreate my app from scratch.
Thanks in advance !
Solved! Go to Solution.
Hi,
This might be an issue to do with renaming the column as SortByColumn uses 'base' column names:
If you open the SharePoint List
> 'Cog' Settings
> List Settings
> Click on that Column to edit its properties
- now in the Titlebar you will see something like this:
This will list the 'base' field name that the field was called before it was renamed - this is what is needed when using SharePoint column names surrounded by " "
Please could you try using this and let me know if this works,
Cheers,
ManCat
@iAm_ManCat |
Please 'Mark as Solution' if someone's post answered your question and always 'Thumbs Up' the posts you like or that helped you! |
Thanks! |
Hi,
This might be an issue to do with renaming the column as SortByColumn uses 'base' column names:
If you open the SharePoint List
> 'Cog' Settings
> List Settings
> Click on that Column to edit its properties
- now in the Titlebar you will see something like this:
This will list the 'base' field name that the field was called before it was renamed - this is what is needed when using SharePoint column names surrounded by " "
Please could you try using this and let me know if this works,
Cheers,
ManCat
@iAm_ManCat |
Please 'Mark as Solution' if someone's post answered your question and always 'Thumbs Up' the posts you like or that helped you! |
Thanks! |
Thank you for answering.
It was indeed the original field name that was still saved somewhere.
I successfully renamed it going to the list parameters and editing the column parameters there.
I now can call the column by the modified name.
It's still strange that editing the title of a column inside of the list isn't doing the same thing as editing it inside the list parameters..
Thanks,
Sriks
Hi,
Yes it's a 'SharePoint quirk' - I've written about it in more detail here:
Cheers,
ManCat
@iAm_ManCat |
Please 'Mark as Solution' if someone's post answered your question and always 'Thumbs Up' the posts you like or that helped you! |
Thanks! |
User | Count |
---|---|
121 | |
86 | |
83 | |
74 | |
69 |
User | Count |
---|---|
215 | |
179 | |
140 | |
108 | |
83 |