User Profile
BradD
Brass Contributor
Joined Jun 17, 2020
User Widgets
Recent Discussions
Re: Client ID - 0c4b69a8-adac-4ec1-b310-6c28ff9fa263 Does NOT exist in App registrations.
You need to create your own client from your own tenant, apply the necessary roles/auths and go from there. You need to read up on creating a service principal. https://docs.microsoft.com/en-us/azure/active-directory/develop/howto-create-service-principal-portal#register-an-application-with-azure-ad-and-create-a-service-principalRe: Re: API to search list of videos or channels with strings in microsoft streams
API’s are coming but haven’t dropped yet. There was an announcement a little while back. If you can’t wait, you can build some kind of flow and throw the videos into Azure Media Services and from there, you can get a transcript and then use that to search and link to your video. A little long winded but all possible. Someone may have a better answer so not sure if that helps.Re: Excell has won this round
Byn138 yeah, that'll never work. It's not that simple and you'll never get a result using VLOOKUP like that. I changed it which is more complex and there's probably a better way but it works. It's using an array formula which you should probably read up on if you want to go with this approach. I also changed the format of your fees table so it's using scales rather than ranges.Re: Currency Conversion List to List Calculation
You could use a Logic App to read for updates to the two lists and then use an Azure function to perform the calculation using the Graph API. The part I’m not clear on though, where do you want to store the EUR amount? In the main list on the same record where the local currency amount is?Re: Excel save issue for xls type file when office 365 is installed
XLS files are now extremely old and support for such files is diminishing especially with the cloud approach. XLS files are binary whilst the newer XLSX files are XML based. You should ask yourself the question, does it need to be XLS? If there’s absolutely no good reason then you should just convert it to XLSX/XLSM.Re: Copy SharePoint List to the another new site
sbhan4 you can add a new list via "Site Contents" referencing the list from the other site. This will being over the structure and any dependent lists. Then, export all of the data from the other list(s) out to Excel and then import it into the new list(s). You'll lose, history, etc. but at least you have your data. There may very well be cleaner/better ways but it's simple enough.Re: How does file size of a PowerPoint work?
PowerPoint files are already zip files. If you convert the extension of the file to .zip you’ll see it contains a set of XML files and the like. The user could check the zip contents before and after to see which specific files are or are not changing and where the volume of the KB's are located. You'll find images and all sorts of things in the zip file so targeting specific files and their sizes will be easy. I can't promise that the person comparing the zip contents will always understand what they're looking at though.Re: How to lock a spreadsheet in Sharepoint
SheriW but regardless, again, it's still Excel. I just tested it myself. I created a new workbook, opened it in the desktop app, locked it (and it saved automatically) and then when I go back to the online view, it's locked and I cannot edit it. You can't edit the protection in the online view but that doesn't stop you from opening it in the desktop app and making those changes. If that's now what you're after then I'm clearly misunderstanding your issue.
