Importing dates from Excel into Sharepoint list
Hi, I've tried various forums for answers to this issue but none have succeeded. I have an extensive spreadsheet that I want to import a Sharepoint list. The issue is the date column. irrespective of how I format the date in Excel it does not conform to the date/time format in Sharepoint. The error message (note the error varies depending on how I format in excel) I am sure there should be a simple function fix but I suspect I don't have sufficient knowledge to understand potential solutions offered on other forums. any help/advice gratefully received.Transforming Expense Management: Award-Winning Expense Tracker App at the Power Platform Hackathon
Discover how the Expense Tracker App revolutionized expense management and emerged as the champion at the prestigious Global Power Platform Hackathon held in Nairobi. Explore its innovative features, seamless integration, and powerful analytics that enable businesses to track their sales expenses with ease and make informed financial decisions. Dive into the success story of this groundbreaking app and learn how it is reshaping the way organizations manage their finances.
Teams Desktop App not loading sharepoint List in Guest account
I have access to a guest Teams group for collaboration between two companies. We have a List tab added to a channel and the correct access granted. I can access the List on SharePoint via web browser, and through the Teams web app. However, the List in the desktop app tries to load for about 20-30 seconds and then says sorry it can't load. Based on what we've tried it seems to be a bug problem in Teams desktop.
Sending individual emails based on a multiple selection person/group column
Hi, I'm trying to isolate the individual email addresses based on a multiple selection person/group column and then send the individual an email rather than all email addresses in the column. Is there a solution for this through Power Automate?SharePoint List in Teams - One list added to by multiple Teams that see only seeing their data
Wanting to know if it's possible to create a SharePoint List (SharePoint Online) that multiple Teams can contribute to, however that can only see their information. Requirements: An overarching SharePoint List to capture all data from multiple Teams Multiple Teams to contribute multiple items to the list via a Teams tab (no need to see SharePoint) Individual Teams can only see their data, not other Teams Individual Teams will have a unique ID associated with them, located in a SharePoint Master List of Teams Any changes to the overarching SharePoint List would reflect in all Teams views (for example adding a new column/ field and any custom settings). This is an important difference as it means we cannot (at least I don't think we can) make individual lists for each Team and use a Flow to push to a master list. Example: A Risk Register as an overarching SharePoint list to capture all risks from all projects Each project has a Teams structure set up for it, with a view of the Risk Register & all its fields via a tab - not requiring to open SharePoint, all data can be added directly through Teams. Individual projects add their risks to the register in Teams, populating the overarching Risk Register in SharePoint Individual projects cannot see data from other projects, only their own risk data Each project has a unique ID in a Master List in SharePoint (if unique IDs help with a solution) Any change to the Risk Register structure in SharePoint is reflected immediately in all project view through their Teams tab. e.g. adding a new field to the SharePoint list will show that new field in all Teams On the back-end in the Risk Register SharePoint List, admins can see all risks raised by all projects Hopefully this is quite simple and there's an out-of-the-box solution! Thanks in advance
JSON Header Formatting Issue
Hello, I am having trouble with the code below. This code is adjusted from https://github.com/rdorrani/SharePoint/blob/master/TravelRequest/headerformatting.json header formatting. Here are the issues I am having: Manager Approval-->Not Approved: I would like for this to be red. The entire circle disappears when I try to adjust the "Not Approved" code Ethics Approval: This code works just fine. I would like to know how to delete the HR approval codes without jeopardizing the ethics approver code. For example, when I remove everything that has to do with HR Approval, the entire circle disappears (Fig 1) SNL Approval: This circle stays green even if their is nothing in the column. If someone's name is entered in the column "SNL Approver Name", then it should be green, like Ethics Approval. I tried using the same code as the Ethics Approval but it does not work. (The approver name column for this one is "Person Group' while Ethics is "Single Line Text") I would also like to get rid of the unnecessary HR approval codes (circle disappears when adjusting it) Fig. 1 { "elmType": "div", "attributes": { "iconName": "=if([$Ethics_Approver_Name] != '' ,'CompletedSolid' ,'CircleShapeSolid'))", "class": "=if([$Ethics_Approver_Name] != '' ,'ms-fontSize-42 ms-fontColor-green',if([$Ethics_Approver_Name] == '' ,'ms-fontSize-42 ms-fontColor-yellow','ms-fontSize-42 ms-fontColor-neutralTertiary'))" } { "elmType": "div", "style": { "margin": "5px", "width": "100%", "height": "160px", "border": "2px dashed", "padding": "10px", "display": "flex", "flex-direction": "column", "align-items": "center" }, "children": [ { "elmType": "div", "txtContent": "Project Initiation (PI)", "attributes": { "class": "ms-fontSize-28 ms-fontWeight-bold" } }, { "elmType": "div", "style": { "display": "flex", "justify-content": "center", "width": "100%" }, "children": [ { "elmType": "div", "style": { "display": "flex", "flex-direction": "row" }, "children": [ { "elmType": "div", "style": { "width": "140px", "display": "flex", "flex-direction": "column", "align-items": "center", "margin": "20px" }, "children": [ { "elmType": "div", "txtContent": "Manager Approval", "style": { "margin-bottom": "5px" }, "attributes": { "class": "ms-fontSize-15" } }, { "elmType": "div", "attributes": { "iconName": "=if([$Manager_Approval] == 'Approved' ,'CompletedSolid', if([$AD_Approval] == 'Not Approved' ,'CompletedSolid' , 'CircleShapeSolid'))", "class": "=if([$Manager_Approval] == 'Approved' ,'ms-fontSize-42 ms-fontColor-green', if([$AD_Approval] == 'Approved' ,'ms-fontSize-42 ms-fontColor-green',if([$AD_Approval] == 'Pending AD Approval' ,'ms-fontSize-42 ms-fontColor-yellow',if([$AD_Approval] == 'Not Approved' ,'ms-fontSize-42 ms-fontColor-yellow',if([$Manager_Approval] == 'Pending Manager Approval' , 'ms-fontSize-42 ms-fontColor-yellow' ,if([$Manager_Approval] == 'Not Approved' , 'ms-fontSize-42 ms-fontColor-red' , 'ms-fontSize-42 ms-fontColor-neutralTertiary'))))))" } } ] }, { "elmType": "div", "style": { "width": "80px", "display": "flex", "flex-direction": "column", "align-items": "center", "margin-top": "50px" }, "txtContent": "---------->", "attributes": { "class": "ms-fontSize-16" } }, { "elmType": "div", "style": { "width": "120px", "display": "flex", "flex-direction": "column", "align-items": "center", "margin": "20px" }, "children": [ { "elmType": "div", "txtContent": "🧐AD Approval", "style": { "margin-bottom": "5px" }, "attributes": { "class": "ms-fontSize-15" } }, { "elmType": "div", "attributes": { "iconName": "=if([$AD_Approval] == 'Approved' ,'CompletedSolid' , 'CircleShapeSolid')", "class": "=if([$AD_Approval] == 'Approved' ,'ms-fontSize-42 ms-fontColor-green',if([$AD_Approval] == 'Pending AD Approval' , 'ms-fontSize-42 ms-fontColor-yellow' ,if([$AD_Approval] == 'Not Approved' , 'ms-fontSize-42 ms-fontColor-red' , 'ms-fontSize-42 ms-fontColor-neutralTertiary'))" } } ] }, { "elmType": "div", "style": { "width": "80px", "display": "flex", "flex-direction": "column", "align-items": "center", "margin-top": "50px" }, "txtContent": "---------->", "attributes": { "class": "ms-fontSize-16" } }, { "elmType": "div", "style": { "width": "140px", "display": "flex", "flex-direction": "column", "align-items": "center", "margin": "20px" }, "children": [ { "elmType": "div", "txtContent": "Ethics Approval", "style": { "margin-bottom": "5px" }, "attributes": { "class": "ms-fontSize-15" } }, { "elmType": "div", "attributes": { "iconName": "=if([$Ethics_Approver_Name] != '' ,'CompletedSolid' ,if([$ApprovalStatus] == 'Rejected by HR' ,'CompletedSolid' , if([$ApprovalStatus] == 'Pending HR Approval' ,'CompletedSolid' ,'CircleShapeSolid')))", "class": "=if([$Ethics_Approver_Name] != '' ,'ms-fontSize-42 ms-fontColor-green', if([$Ethics_Approver_Name] == '' ,'ms-fontSize-42 ms-fontColor-yellow', if([$ApprovalStatus] == 'Pending HR Approval' ,'ms-fontSize-42 ms-fontColor-green',if([$ApprovalStatus] == 'Rejected by HR' ,'ms-fontSize-42 ms-fontColor-green',if([$ApprovalStatus] == 'Pending Manager Approval' , 'ms-fontSize-42 ms-fontColor-yellow' ,if([$ApprovalStatus] == 'Rejected by Manager' , 'ms-fontSize-42 ms-fontColor-red' , 'ms-fontSize-42 ms-fontColor-neutralTertiary')))))" } } ] }, { "elmType": "div", "style": { "width": "80px", "display": "=if([$Are_x0020_you_x0020_using_x0020_] =='CSI','block', 'none')", "flex-direction": "column", "align-items": "center", "margin-top": "50px" }, "txtContent": "---------->", "attributes": { "class": "ms-fontSize-16" } }, { "elmType": "div", "style": { "width": "120px", "display": "=if([$Are_x0020_you_x0020_using_x0020_] =='CSI','block', 'none')", "flex-direction": "column", "align-items": "center", "margin": "20px" }, "children": [ { "elmType": "div", "txtContent": "SNL Approval", "style": { "display": "=if([$Are_x0020_you_x0020_using_x0020_] =='CSI','block', 'none')", "margin-bottom": "5px" }, "attributes": { "class": "ms-fontSize-15" } }, { "elmType": "div", "attributes": { "iconName": "=if([$SNL_Approver_Name] != '' ,'CompletedSolid' , 'CircleShapeSolid')", "class": "=if([$SNL_Approver_Name] != '' ,'ms-fontSize-42 ms-fontColor-green',if([$ApprovalStatus] == 'Pending HR Approval' , 'ms-fontSize-42 ms-fontColor-yellow' ,if([$ApprovalStatus] == 'Rejected by HR' , 'ms-fontSize-42 ms-fontColor-red' , 'ms-fontSize-42 ms-fontColor-neutralTertiary'))" } } ] } ] } ] } ] }Pulling Data from SharePoint List into Excel
Hi, I have successfully pulled data from SharePoint List into excel using "Get Data from Online Sources" for further analytics. One issue I am running into is in regards to certain data types. It appears when certain columns of data where multiple choices can be returned for data in the column, it appears in excel as [List] instead of showing what might have actually been returned in the SharePoint List. Is there a way to correct this?
