Buy/Selling at online exchanges – Bitcoin Stack Exchange

I’m on an exchange website, Gemini, and I’ve got a quick question in general about such exchanges:

Say I want to sell/buy a digital asset (eg: bitcoin) at a certain time. Will my transaction be executed against the price at that moment in time, or at a later undetermined time?

403-forbidden error running sharepoint online search rest api from c# console appl

I am trying to run below sharepoint online search rest api in c# console application but receiving error. the account/username i am using is already a global admin and sharepoint site collection admin and owner.
I am receiving 403 Forbidden error. Can someone suggest what permissions/authorization am i missing?

Can someone give me working example reference? i am using GET.

I am referring to example in below thread
https://stackoverflow.com/questions/59470250/i-want-to-implement-sharepoint-document-search-using-c-sharp-api

https://xxxxxx.sharepoint.com/sites/scr/_api/search/query?querytext=%27scStatusOWSCHCS=Expired%27

Buying goods online from Canada to EU is VAT free?

I read that Canada and EU now have a free trade agreement. Does this mean that as a private person, if I order some goods online, like a laptop, or a TV, or anything will be VAT free if it comes to the EU?

sharepoint online – Power Automate Disabling Infrequently Used Flow

How can I prevent infrequently run flows from being automatically disabled?

I recently received an email about a flow I have that doesn’t run very often with the following message:

We noticed that your flow has not run at all in the past 90 days. If it does not run it will be turned off in 7 days.

This is very inconvenient for me, but I can’t find any documentation regarding this policy or how to disable it (if that’s even possible).

Some possibly relevant details:

  • We are using the Microsoft Power Automate Free license with Microsoft 365 E3

  • This flow is part of a document approval process and doesn’t make sense to have run periodically to avoid this apparent 90-day limit.

Has anyone else encountered this / has anyone had success disabling this feature?

sharepoint online – Conditional formatting based on number of days to due date

In SharePoint 0365, in the modern experience, I have a list of
contracts that have an expiration date.

I would like to use conditional formatting to create a status
column that shows me the contract is one of these:

  1. Active, Green background – due date is more than 4 month from today.
  2. Expiring, Orange background – due date is between 4 month from today and today.
  3. Expired, Red background – due date is past one day.

I’m trying to get this for while now without success. I matched the formulas in Excell where they’re working.

This is the code I’m trying:

{
  "elmType": "div",
  "style": {
    "background-color": "=if(($DueDate) > @now + 1036800000 ,'green', (if(($DueDate) - @now >= 0, '#ffa59b','red'))"
  },
  "children": (
    {
      "elmType": "span",
      "txtContent": "=if(($DueDate) > @now + 1036800000 ,'Current', (if(($DueDate) >= @now - 10368000000, 'Expiring','Expired'))",
      "style": {
        "color": "white"
      }
    }
  )
}

And this is the result I get:

SharePoint library screen capture

Here is the working formula tested in Excel, I’m trying to convert in JSON : =IF(B16>TODAY()+120,”green”,IF(B16-TODAY()>=0,”orange”,”red”)) where B16 is the cell containing the contract due date.

sharepoint online – Is this a bug ?only 30 items in the List showing and i need to inspect the page for the rest to show up

Stack Exchange Network


Stack Exchange network consists of 176 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

sharepoint online – Slide library replacement

I am way late to this party but since I went thru the pain of understanding it, I thought I would share what we did.

It is indeed a watered down limited solution at this point with no integration to newer versions of the powerpoint desktop app (Any MS Office Powerpoint Desktop App newer than 2013 doesn’t work), as all those features were removed after 2013.

You can’t add slides from the newer MS Powerpoint desktop App, have to do it through IE only browser (Other browsers aren’t supported) publishing is not available in newer Powerpoint Desktop App. You can however trim down the uploaded PowerPoint Presentation to fewer slides by selecting only certain slides during that step (Which really is the only feature that I can say still exists in the whole process).

On the other side of things getting slides out of the Slide Library is virtually impossible using a newer version of the PowerPoint Desktop App…

So what you have to do is use the ‘download a copy’ button for each presentation that you want a slide from and download each presentation locally… (Yeah great way of doing things right Microsoft… << Insert Sarcasm HERE >>)

After you have all the old presentations locally and the new ‘in-progress’ presentation open in a newer version of the PowerPoint Desktop App all you have to do is use the ‘Reuse’ (button) feature to browse to each local copy of the old downloaded presentations and select the slides you want, then move on to the next old presentation and repeat until you ‘inserted’ all the slides from the old presentations you want.

Afterwards you can use PowerPoint as normal to modify the slides and such that were ‘inserted’ into the newer ‘in-progress’ presentation.

Not nearly as elegant as it once was and really the only thing it gets you is the feature of trimming down your presentations when being uploaded, but it is what it is.

I tried mapping a folder location to the Office 365 Slide Library location to see if I could trick PowerPoint into letting me do it that way, but got an error saying ‘You cannot use an Internet address here…’

Such a bummer, because it was a good centralized integrated way of managing slides and presentations, but that is the only option I see, short of staying in an all 2013 environment of course…

I should mention that after we put the process in place we created some basic self paced training videos and uploaded in 0365 Stream for users to walk-thru the process b/c is not integrated. We thought that might help eliminate some of the end-user frustration with this issue.

SG.

Unable to upload to SharePoint Online via VBA

I have tried using the below code to upload a document to SharePoint Online (Sourced from this answer)

Dim SharepointAddress As String
Dim LocalAddress As String
Dim objNet As Object
Dim FS As Object

' Where you will enter Sharepoint location path
SharepointAddress = "\sharepoint path to document library"  & "" 

 ' Where you will enter the file path, ex: Excel file
LocalAddress = "H:/test.gif" 

Set objNet = CreateObject("WScript.Network")
Set FS = CreateObject("Scripting.FileSystemObject")
If FS.FileExists(LocalAddress) Then
    FS.CopyFile LocalAddress, SharepointAddress
End If
Set objNet = Nothing
Set FS = Nothing

I have signed in to the SharePoint Online site using my work credentials and then navigated to the library and copied the address from the URL bar to paste into the above code, however when I try to run the procedure I am getting an error message saying Run Time Error 76: Path not found

Does anyone know what I am doing wrong? Thanks

powershell – catch statement does not work SharePoint Online PNP

I had the same issue of not being able to catch exceptions with Add-PnPListItem. Running it in a variable and adding -ErrorAction Stop worked for me.

Using parts of the OP’s script for this example, this is what worked:

try 
{
    $getTheFile = Get-PnPFile -Url $fileUrl -Path $fullExportPath -FileName $fileName -AsFile -ErrorAction Stop
    $getTheFile
}
catch
{
    Write-Host "Issue occurred while getting: $($fileName):" -Foregroundcolor Red
    Write-Host "$($_.Exception.Message)" -Foregroundcolor Red
    $failedDocItems++
}
    

sharepoint online – How to format calculated column number in Flow

Use below formula:

formatNumber(int(outputs('<Get SharePoint Data Action Name>')?('body/<calculated column name>')), '0,0.00', 'en-us')

This will convert your calculated column to #,#.00 format (with 2 decimal points).

If you want the number without decimal points then you can use below formula:

formatNumber(int(outputs('<Get SharePoint Data Action Name>')?('body/<calculated column name>')), '0,0', 'en-us')

Replace Get SharePoint Data Action Name and calculated column name with your action name and calculate column name respectively.

You can convert the string to number in Microsoft flow using int function.

And You can format the number to desired format in Microsoft flow using formatNumber function.

Flow:

enter image description here

Output:

enter image description here