sharepoint online list
13 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)644Views0likes0CommentsNon-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.3KViews0likes2CommentsDeploy SharePoint List from one SharePoint Site to Another SharePoint Site
Hello everyone, I'm using SharePoint as a backend in the Power Apps Canvas App. I'm having 2 SharePoint sites let's say DEV_Site and PROD_Site which will have the same structure i.e. PROD_SIte will be the exact replica of DEV_Site (Just to distinguish Development and Production environment). Now, my concern is how I can deploy all the lists from DEV_Site to Prod_Site once I made appropriate changes to the lists of DEV_Site. The ultimate goal is to Update existing lists and Add new lists in the PROD_Site based on DEV_Site. Can anyone know how I can do this? Any suggestion or solution will be highly appreciated.799Views0likes0CommentsTeams 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-formatting932Views0likes0CommentsSomething 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.5KViews0likes2CommentsHow does a SharePoint Folder link to a SharePoint Online List
Hi I am building a Power BI dashboard that links to a SharePoint Folder. I have added the Approve and Reject option for a document. I was hoping to pull this data into my PBI dashboard. So I am using the SharePoint Folder connect or to get this, however this does not contain the Accept or Reject status - so I am assuming this stored in the Documents section of a SharePoint Online List. But I don't see how these two entities link together See attached screen shots of what I am trying to do Any thoughts would be greatly appreciated IG1.1KViews0likes0Comments