Skip to main content

Notifications

Power Automate - Using Connectors
Unanswered

invoking Custom function

(0) ShareShare
ReportReport
Posted on by 3

Hello, Everyo

I was trying to Fetch Data from Stock Site for particular Symbol for a Period of Time.

I have Created the Function Name "FromDate" & "ToDate" for that, But the query returns expression error (as shown in Attached Image).

 

please anyone can help me with this. I am Novice in Coding Languages.

Untitled2.pngUntitled.png

  • RaviSheth Profile Picture
    RaviSheth 3 on at
    Re: invoking Custom function
    Hello Steve,
     
    thank you for your quick response.
     
    I want to Make change in Following sentence 
     
    In Highlighted Place I want to use Function Which uses date data type.
     
    Source = Csv.Document(Web.Contents("https://www.nseindia.com/api/historical/cm/equity?symbol="&Symbol()&"&series=[%22EQ%22]&from=14-12-2019&to=14-06-2020&csv=true"
     
    following are the way I have created this two function 
     
    1.I have created two table named FromDate & ToDate with date data type and formatted in exactly the way highlighted text are.
     
    2. Turned it into a Function through advance editor
     
    Now ToDate use TODAY() function of excel to extract todays date & FromDate gets data by (Duration in Day - ToDate)
     
    so how would I use this two Function in above sentence to get exact data.
     
    Source = Csv.Document(Web.Contents("https://www.nseindia.com/api/historical/cm/equity?symbol="&Symbol()&"&series=[%22EQ%22]&from="&FromDate()&"&to="&ToDate()&"&csv=true"
     
    this is what I have tried but retuned Expression error as You have mentioned we can't use & in Text and date.
    I have also tried without & and without ""this also. but it didn't get desired results. i have tried everything on net and books but not able to get the answers.
     
    please help.
     
    thanks
  • SteveYao Profile Picture
    SteveYao on at
    Re: invoking Custom function

    Hi @RaviSheth 

     

    Could you check your formula? It seems the left and right operand are not the same type, you cannot use & with Text and Table

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,567

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard

Featured topics