Runtime selection of dataset, not through manifest file

Options
zmenzer
zmenzer Member

Currently testing using either vanilla javascript or React as a target framework. Not looking to deploy this on App Studio yet. We are not on consumption yet, so no workflows currently for this, but workflows still might not solve this particular item.

I've created a test application to allow users to approve exceptions. Data comes in nightly, and if something sits outside what we consider "normal," it gets flagged as an exception. However, there are inevitably several "known" exceptions that the users either don't want to see in their exception reporting or are known exceptions that have been approved. The application brings in information from a dataset, filters it down based on column x in the database, and allows the users to click a checkmark "approve" button. The approval gets written back to the collection database and queried at runtime to hide prior approved exceptions. This is a simple table structure being displayed to the users. Nothing too fancy.

However, to get this to work, as I know it today, I would need to have each of the possible datasets included in the manifest file and create logic to know that this specific card was selected to point at this specific dataset. But, if a user wants to add in a new dataset, we'd have to redeploy the app to account for this new ID. This would then potentially cause performance issues if we have 10-20 datasets included? (I may be overthinking this one)

So, is there a better way to handle this? Can I have users dynamically point to another dataset ID at runtime if they want a new exception (such as through a list of known datasets from one of the governance datasets)? Or is the way I have proposed above about the only way that can easily be leveraged to complete this task?

Best Answer

  • GrantSmith
    GrantSmith Coach
    Answer ✓
    Options

    Custom apps don't support dynamic dataset changing. Have you thought about combining your datasets together via a dataset view or dataflow into a single dataset and use that output dataset to power your App?

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓
    Options

    Custom apps don't support dynamic dataset changing. Have you thought about combining your datasets together via a dataset view or dataflow into a single dataset and use that output dataset to power your App?

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**