I'm looking to find confirmation if I'm looking at this the right way. I've gone through the guided learning and a fair amount of posts over the Internet, but I'm entirely new to Powerapps and Flows, so forgive me if I'm missing something.
I'm looking to create a demo app, simply for the purpose of familiarizing myself with PowerApps.
What I want to do is create a PowerApp that I could use to track the time I spent on an assignment and store it into the CDM. The exact lay-out of the app doesn't matter, but the premise is that I want to keep track of time I spent for a customer, but specifically gets all customer records from the customer page in NAV. I've published a webservice to do that, which works.
Because I'm really working with two data sources (NAV's webservice for customers and a place to store time entries), I was thinking to use a flow to populate/map the customer data from NAV, into the account entity for CDM. What I've currently done:
- Retrieve customers from an NAV instance, hosted on Azure by a cloudpartner. I can create a connection a run a simple sample app on that data that works just fine.
- Create a Common Data Model, that stores very simple information (code and name will do) on those customers, in the account entity
- Create a PowerApp that allows me to populate a custom entity in the CDM called "Time entry". I'm thinking about a start/stop button and a dropdown list showing the customer names to register time on. OR a manual entry screen, if my previous solution is a bit too ambitious for me at this stage 🙂
From my understanding, I can't do a one-off "get all records from the NAV database and store them in CDM", I can only use the create/update trigger. So I'd have to do a one-off import and then use the flow to trigger new additions/modifications to the records. However, this flow never fires. It just sits there, despite one or more creates over the course of an hour.
My questions:
- Is that normal? I simply used a blank Flow template, used the NAV connector, used the CDM connector and the flow creates just fine, it just doesn't seem to do anything. Not a single run in the history for 1+ hrs.
- Is my premise correct? I can use the CDM to gather data from several sources, map them to become "standardized" with CDM (or use custom entities)?
If not, what would the ideal approach be?
Do note, I'm just wondering on anyone's viewpoint or opinion, I'll try and figure out the rest myself 🙂
Thx!
