Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Create a dynamic value for Json.Document function

Hi All,   I'm using the function Json.Document to get data from an API. Below is the an example of the Json.Document value:   Json.Document(Web.Contents("https://url.com/site/222222/energyDetail...
Tips and Tricks
lbendlin's avatar
lbendlin
Super User
3 years ago
startTime=DateTime.ToText(#"Site Data - Start and End Date"[dataPeriod.startDate]){0}
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Thanks lbendlin for your feedback.

 

I still have the same error message after adding "{0}":

 

startTime=DateTime.ToText(#"Site Data - Start and End Date"[dataPeriod.startDate]){0}

 

 

I tried to added inside the DateTime.ToText() function and I got the error message as below :

 

startTime=DateTime.ToText(#"Site Data - Start and End Date"[dataPeriod.startDate]{0})

 

Any help ?