User Profile
FastTrack-F1
Copper Contributor
Joined 6 years ago
User Widgets
Recent Discussions
Re: Highlight active row/column in Excel
NikolinoDEThanks for your proposals, but did you test them in Excel online? I cannot see a working solution! Work with VBA macros in Excel for the web: "Although you can't create, run, or editVBA (Visual Basic for Applications) macros in Excel for the web,..." Conditional formatting also does not work, as it needs manual recalculation...5.8KViews0likes3CommentsHighlight active row/column in Excel
Hello, for the Excel desktop app there are different ways to highlight an active row/column. In Excel Online I sometimes really struggle to see the active cell, especially in meetings when presented by projector. Is there any way to get these settings changed in Excel Online? Thanks6KViews0likes7CommentsRe: Dynamic Deep Linking from SharePoint page
ganeshsanap Thanks for the quick reply! Unfortunately I now have to start a fight with our IT to install it on my site... @Microsoft: Why do you always cut existing, useful solutions? SharePoint 2010 might not have looked so nice like modern page design, but at least as a site owner you could implement technical solutions that fit your needs.Dynamic Deep Linking from SharePoint page
Hello, I want to open a PowerApp from a SharePoint page, but PowerApp has to know from which page it was opened in order to filter on the right dataset. Unfortunately modern SharePoint does not have a content editor web part anymore where I could embed a JavaScript that might be able to find the URL it was embedded into. So my problem is to find the information from where PowerApp got started, not the deep linking itself... Are there any solutions?SolvedRe: How to migrate from excel to sharepoint list
Murali_krishna_P You can also use VBA, code below needs to be modified to loop through your Excel Sub NewSharePointItem() 'Reference to be added: Microsoft ActiveX Data Objects 6.0 Library Dim con As ADODB.Connection Dim rs As ADODB.Recordset Dim SQL As String Set con = New ADODB.Connection Set rs = New ADODB.Recordset SQL = "select * from [NIFdb] ;" With con .ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;WSS;IMEX=2;RetrieveIds=Yes;DATABASE=https://xyz.sharepoint.com/sites/site/;LIST={81e876da-1d06-4c9f-bc40-177e66b97db6};" .Open End With rs.Open SQL, con, adOpenDynamic, adLockOptimistic rs.AddNew rs.Fields("Column1 Name here") = cell(1,1) rs.Fields("Column2 Name here") = cell(1,2) rs.Update rs.Close If CBool(rs.State And adStateOpen) = True Then rs.Close Set rs = Nothing If CBool(con.State And adStateOpen) = True Then con.Close Set con = Nothing End Sub1.4KViews0likes0CommentsRe: O365 SharePoint images disappeared
Since March 23rd 2022 images from the image column are broken on our SharePoint Sites. See my post here: https://techcommunity.microsoft.com/t5/sharepoint/sharepoint-image-column-broken/m-p/3265705 It cannot be that something is working and then suddenly Microsoft downgrades a link to 100 characters like mentioned by DaveMehr3656.2KViews0likes0CommentsSharePoint image column broken
Hello, On a SharePoint Online List I have 4 image columns that are populated with PowerAutomate (for details here the tutorial:https://www.youtube.com/watch?v=3QWxVWbwRSM). Since yesterday almost all images are broken, the link gives this error message in the browser: {"error":{"code":"invalidRequest","message":"Invalid request"}} For one colleague it still works in Edge but not Chrome List snapshot: Flow details: I am grateful for help FastTrack2.1KViews0likes2CommentsRe: Manage a Project task in Planner
Trutz_Stephani The third scenario is what I need... I have Project for Office 365 MSO, e.g. Microsoft Project Online Desktop client - you say sscenario 3 will work with this subscription? Otherwise uur IT will try to set up the FluentPro Project-Planner-Synch-tool...7.3KViews0likes1CommentRe: Manage a Project task in Planner
Hi Trutz Stephani, Thanks for your answer, but this Microsoft solution is not worth to be promoted... I have seen this functionality of Project 2016 - and therefore I am highly disappointed of Microsoft! A line Item in Project should resemble a task in the Planner, have a look from minute 38:00 onward: https://www.youtube.com/watch?v=M2ieovakND8 To have a hyperlink from a line item in Project to the Planner is extremely poor and Microsoft should be ashamed to promote this! Use a freetext-field in Project, Ctrl+K, write the Planner Name and enter the Planner URL. With this solution you can even see to which Planner you linked and sort for tasks linked to a certain Planner... BR, FastTrack7.3KViews1like3Comments
Groups
Recent Blog Articles
No content to show