10,730
edits
Important: Deprecating old WebView — Publish failed error
Power Automate: Difference between revisions
Jump to navigation
Jump to search
→Available connectors
Marek Rodak (talk | contribs) No edit summary |
|||
| Line 17: | Line 17: | ||
;[[Resco Reports connector]] (preview): Generate Resco's [[mobile report]]s directly from the [[Dynamics]]/Dataverse backend | ;[[Resco Reports connector]] (preview): Generate Resco's [[mobile report]]s directly from the [[Dynamics]]/Dataverse backend | ||
== Sample Power Automate flows == | |||
We have prepared several sample Power Automate flows with Resco data to showcase some of the possible use cases of this technology. | |||
=== Questionnaires in Excel table === | |||
'''Used connectors:''' Microsoft Dataverse, Excel Online | |||
'''Description:''' This flow is triggered when any new Questionnaire is submitted by mobile user in Dataverse. If this questionnaire is not type of template, the body of answered questionnaire, which is initially in the JSON format, is processed and parsed into excel table. | |||
'''Business value:''' We show how to transfer data harvested via Inspections into XLS for further analytics. | |||
'''Prerequisites:''' Forms + solution/Resco Inspections tables enabled in Dataverse | |||
'''Link:''' [https://docs.resco.net/mediawiki/images/5/52/ParseJSONQuestionnaire.zip Parse JSON Questionnaire] | |||
=== Questionnaires in Power BI === | |||
'''Used connectors:''' Microsoft Dataverse, Power BI | |||
'''Description:''' This flow is triggered when any new Questionnaire is submitted by mobile user in Dataverse. It then refreshes the dataset of Power BI workspace. Dataset refresh is required when postprocessing of JSON in Power BI because Parsing JSON in DirectQuery mode is not available. | |||
'''Business value:''' Can be used as help for further analytics of submitted questionnaires in Power BI. | |||
'''Prerequisites:''' Forms + solution/Resco Inspections tables enabled in Dataverse | |||
'''Link:''' [https://docs.resco.net/mediawiki/images/b/b8/RefreshDataSetForPowerBI.zip Refresh Data Set For Power BI] | |||
=== New reported issue in Guides === | |||
'''Used connectors:''' Microsoft Dataverse, Office 365 Outlook | |||
'''Description:''' This flow is triggered when any new Guide Feedback is created by mobile user in Dataverse. If the feedback type is “Guide”, not “Step” and the step ID is not empty, it retrieves a list of system users associated with a specific guide. Then, it sends an email to each user with the comment from the feedback. | |||
'''Business value:''' Can be used as monitoring/notification tool for guides. | |||
'''Prerequisites:''' Steps + solution/Resco Guides tables enabled in Dataverse | |||
'''Link:''' [https://docs.resco.net/mediawiki/images/d/d0/GuideIssueNotification.zip Guide Issue Notification] | |||
=== Generate Work Order report === | |||
TBD | |||
{{Feedback}} | |||
[[Category:Resco Cloud]] [[Category:Dynamics]] | [[Category:Resco Cloud]] [[Category:Dynamics]] | ||