Hello, im faily new to Flow. I have created a custom connector to get data from G Suite. I work in education and we are trying to work out how much Chromebooks are used in our schools. I am getting the below JSON from the connector. I only require the active time, from the previous day. I would then like to split the Data and Active Time so i can use in PowerBI. I have never done calculations In Flow and wouldnt know where to start. If anyone has any suggestions or guidance you can point me towards i would be really greatful.
Hi @AJ42 I'm hoping that I'm understanding your requirement correcty, so here is my approach.
As I have a load of JSON being returned from GCloud, I will first of all need to parse the JSON to make it useable within Flow. You can use the "Parse JSON" action to do this. Add the action into your Flow and then generate the schema by copying your JSON into the "Create schema from payload" link.
What should be returned from the parse action, is an array of objects which I can then interact with. You can use the "Filter Array" action to perform a select on your data, particularly on the date field. To get yesterday's date in the format you want, you will need to combine a number of expressions together:
Community Leader: Black Country PowerApps & Flow User Group
@MatthewGrantAU Thank you so much, that was a great help. It's taken me a week but i have got a flow that is giving me the data i need.
I am now trying to convert Millisecconds to Hours and Minutes in PowerBi from a streaming data set. Has anyone got any links to guides or formulars for this? Im having a look around and seeing what i can find
Many congratulations to the Season 1 2021 Flownaut Crew!
Check out our new profile badges recognizing authored solutions!
Check out the community blog page where you can find valuable learning material from community and product team members!