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.
Inconsistency with JSON Formatted Floating Cards in SharePoint Lists Modern UI
Dear Microsoft Tech Community, I'm reaching out to seek assistance with a crucial aspect of our SharePoint List used for shipment tracking that seems to be adversely affected by the modern UI (when the list is opened with Microsoft Lists). Main Issue: JSON Formatting of Floating Status Cards We employ JSON formatting to display floating status cards within our SharePoint List, offering a quick overview of various shipment statuses. This feature functions flawlessly within the traditional SharePoint site interface, with the card expanding beyond the column width to display content as intended. However, when using Microsoft Lists' modern UI, the card is incorrectly resized to the width of the column. This resizing causes the content to wrap, disrupt the layout, and significantly reduce the card's readability and usefulness. See attached animations below: Animation 01: shows the floating card in the SharePoint site interface, displaying the content in full without any wrapping, allowing for a complete and clear view. Animation 02: demonstrates the problematic behavior in the modern UI, where the same card is squeezed into the column width, causing an unwelcome wrap of text and icons. Additional Note: Absence of a :floppy_disk: 'Save' Button in Modern UI Additionally, we've noticed that the modern UI lacks a 'Save' button when editing items. This automatic saving of every change is not conducive to our workflow as it prematurely triggers our Power Automate flows, intended to run only after a user finalizes their edits. While this issue is secondary to the JSON formatting concern, it still represents a significant deviation from the expected functionality. The complete JSON code used in this specific column to generate the floating card can be found in the link below. ➔ https://replit.com/@AlissonBorges2/Shipment-Tracker-Floating-Card#index.js Request for Guidance and Resolution: I am looking for solutions or workarounds that can help us: Preserve the floating card's full visibility as experienced in the traditional interface. Potentially reintroduce a :floppy_disk: 'Save' button or delay the trigger of Power Automate flows until all edits are complete. Technical Details: Browser: Microsoft Edge for Business Version 119.0.2151.97 (Official build) (64-bit) SharePoint Version: SharePoint Online While I am aware that reverting to the classic UI is a temporary workaround by modifying the list's URL, it is not a sustainable or forward-looking solution. The modern UI offers a range of enhancements that significantly improve user experience and productivity. It's faster, more visually appealing, and reduces the need for manual adjustments, such as column width resizing. Therefore, I am keen on having these issues addressed within the new UI itself. Thanks!
Sharepoint Lists adding item level permissions trouble
Hi All, I have what seems to be a simple ask but can't figure out a solution. Existing current access level settings: The above settings allow the user (lets call him User A) to create and edit only items created by them. 2 questions: 1) Is it possible for User A to grant permissions to User B to edit one or more of his items? 2) Is it possible for an admin and/or list owner to prepopulate items on behalf of User A and User B and allowing then to view and edit them - keeping in mind above settings, users can only see and edit items they created Thanks
Combine different list items (from the same list) into single item
Good Afternoon!, I have a list in SharePoint which has multiple items, and I need the three newest items to be combined into a new item and then to delete those three. None of the columns have info that overlaps, so it should be relatively straightforward considering I don't need to combine text values. Any assistance would be greatly appreciated.
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?
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'))" } } ] } ] } ] } ] }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.
