SharePoint Online list
10 TopicsRegarding SharePoint list data storage
Hi Team, Que 1: I have created SharePoint list and I would like to see that data in SQL server where it stored? How I can view that? Or else anyone can you please tell me How I can save into SQL server. Que 2: I have created employee list in SharePoint I would like to use the same list data into my ASP.NET Core web application. How I can integrate SharePoint to .Net application.1.3KViews0likes2CommentsHELP WITH VALIDATION IN SHAREPOINT LIST (IF, AND, OR)
Hello guys, i need some help coz im triyng and burn my brains out and i cant figure out whats going on. i have a need: if [estado]= "concluido" > turn into mandatory columns [Diagnostico Final] and [Atribuído a] and if [estado]= "Executando Trabalho" or "em transito" or "em Pausa" > turn mandatory only the column [Atribuido a] and if [estado] = "Aguardando Atribuição" or "Cancelada" then do nothing... here's the formula im triyng to apply =IF(AND([Estado]<>"Aguardando Atribuição";[Estado]<>"Cancelada");IF([Estado]="Concluído";IF(AND([Atribuído a]<>"";[Diagnóstico Final]<>"")TRUE;FALSE);IF([Atribuído a]<>"";TRUE;FALSE));TRUE)645Views0likes0CommentsNon-developer here, how do I write SharePoint Calculations for:
I am counting number of days a project is On Hold (a yes/no column) with calculated column: Hold Days =DATEDIF([Hold Begin Date],TODAY(),"d") My question - When project is not On Hold, I want "d" to display "0" Continuing the story above, when the Hold End Date is selected the Hold Days should only display the total days between Hold Begin Date and Hold End Date (right now it still accumulates days). Some background, I'm a writer rarely an excel user or formula developer. Please, explain what to do and why so I learn; looks like I may be "writing" more formulas (or begging for your help!). Thank you so, so much!Solved1.3KViews0likes2CommentsExternal data in list column
hello everyone, I'm trying to connect a column of a SharePoint list with a column of an Excel file in OneDrive to have the list of social names of customers, I arrived at the screen that I attach but I do not know if it can be done and in case how. Can anyone help me?1.3KViews0likes2CommentsTeams list update via excel
HI, I have uploaded a Excel Sheet into teams via sharepoint. Occasionally we want to update the data of that list using Excel. Exporting the list from SharePoint to Excel is no problem, but consequently importing it back and replace the list data with the updated Excel Sheet seems more difficult. How can I do this? Thank you.11KViews1like3CommentsSharePoint online Column Formatting
Hi I have a sharePoint multiline column (rich text enabled) in a library and using flow I have added data as: <div>item1</div><div>item2</div>.. When I view the library I can see the items arranged vertically (as I want) but the view gets truncated after the 4th item, otherwise the row height would get too large. Is it possible, on hover over that all the items in the column field can be shown- maybe in a custom card or something else. I've added divs around every item but havent added a container div as this gets difficult to implement through flow, especially when I need to update and maintain previous data. I've looked at MS docs but there is no example where an outer div is not used. - https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting#get-started-with-column-formatting937Views0likes0CommentsSomething Went Wrong! Unable to Group By Field in SharePoint List
Hi All, I've had a user report an issue to me which I've been able to replicate but I can't put my finger on what's causing the issue. We have a SharePoint List which as it stands contains approx 350 items and has 10-15 fields. The issue that occurs is, if you're in a view (effects multiple views and I can't spot any similarities, and no existing groupings within this view) and would like to 'Group By' a field within that view, it initially displays the grouped view for a few seconds and then hits you with a 'Something Went Wrong' Message (Screenshots below). Any suggestions on what could be causing this would be greatly appreciated. Thanks in advance.5KViews0likes2CommentsGet Create by name not being retrive
I'm trying to format a list view via JSON, and am trying to retrieve the name of the person who created the new entry via the below and nothing works, even with different capitalizations. Any ideas? "[$Author.title]" "[$Author.DisplayName]" "[$Author.Name]" Thank you Pepe T765Views0likes0CommentsDropdown list clearing after creating new item
Hi I want to make a new item list (project list) with field taken from other list. (request list) After creating the new project I want the selected items to be gone from dropdown list but not from the request list. (I want workers to look up into request) Example: Create Project 1: Attach request: Request A (selected) Request B (selected) Request C Create Project 2: Attach request: Request C (A and B are gone because they were selected in Project 1) I tried to copy, delate items in MS flow but that didn't` work well... Do you have any ideas?847Views0likes1Comment