Control different Data-sources within variables (Actual & Testing environment within same app)

[aro1]

Hi,

I would really appreciate some support with an issue that I am trying to figure out:

- I would like build an App with Testing + Actual environment within the same app (idea is for easier training & bug fixing)

- I was thinking of using variables inside my Items properties of galleries & setting those variables within the application to either Products_Actual_SharePoint_List or Products_Testing_SharePoint_List.

- Would this be the way to go about this problem or is there any better way?

- The reason I am asking is that I noticed that if Data source is stored within the variable the Gallery does not seem to refresh on its own once a new item is added or existing item is changed for example

Thank you very much in advance.

[WarrenBelz]

Hi @aro1 ,

One approach would be to have a reference list in both areas with a field containing either Test or Prod. Do a Lookup at App OnStart for the relevant value and go from there.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[aro1]

@WarrenBelz 

Thank you very much for your replay. Could you please kindly explain a little bit more on what you meant with a lookup on start for the reference list?

Currently I was looking at 2 options:

1) have all lists for both Test and Real stored as variables on app load --> This seemed good solution as it would simplify changing many of the complex formulas that I have implemented, but does not seem to work well with Galleries, or Patching data...

2) I tried to implement If statements in all my functions (makes functions much more difficult to read...) to take Table-Actual as datasource if gloVarEnv=Production or take Table-Dev if gloVarEnv = Dev...

Thank you very much in advance.

[WarrenBelz]

Hi @aro1 ,

I was referring to an example such as having a list called something like Versions in each environment with one field Version (it also has an ID which will be 1.

At app OnStart, you would do something like this

Set(
   vVersion,
   Lookup(
      Versions,
      ID=1
   ).Version
)
     

then vVersion would be either "Test" or "Prod" and you would base your logic on this.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[WarrenBelz]

Hi @aro1 ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[aro1]

Hi @WarrenBelz 

Thank you very much for your response. I haven't yet managed to figure it out...

Do you mean to store the the development and real SharePoint lists as variable vVersion? I did smth similar but via combobox, but but the issue is that having data source stored as variable is causing delegation issues in my Galleries...

Any ideas?

KR,