Hello,
We have a Solution that has a variable Value 2 Integer. This variable takes a specific number from an app (10 digit at most only Number). In the Flow for this app I need to take Variable 2 Integer and do 2 things with it:
1. Use it to request from the Oracle source DB the PK of table AOPKOPF (column called ID) and assign it to a new variable that will be used by the Flows next steps;
2. Same variable to request the PK from FAKTURA table (column IDFAKTURA) and assign it to another variable for the duration of the flow.
This is my current flow:
Before the GET ROW blocks I need to assign those PK variables and change the variable for Row id.
If you can be as specific as possible with the explanation plus how to make those new variables I would greatly appreciate it. Still quite new to powerapps and I can hardly say I don't know a lot.
What I tried:
Unfortunately this is just empty guesswork and I have no idea how to assign the result to a new variable.
Solved! Go to Solution.
Solution found: Writing for anyone experiencing the same problem.
Be extra careful which field you are trying to select and the requirements that Oracle has for selecting it. In my case I was missing the single quotations only.
FAKTURA table fakturanr I can select with SELECT * FROM faktura WHERE fakturanr=111111
AOPKOPF table belegnummer I cannot select the same way. I needed to do SELECT * FROM aopkopf WHERE belegnummer='111111'
I had to change the logic a bit but here is the working solution (there are '' for the variable):
Okay, I came across a 'solution' of some kind. But now I have another problem. Same setup for 1 flow does not work for the other.
Here is the setup:
And here is the test result:
I get empty string back every time. What is really strange that the same setup works absolutely fine on another Flow.
Here is the correct Flow with the result:
Let me say I wrote the exact same view with columns, I created a new view entirely, I tried different users with different access rights in Oracle. Nothing works for the not-returning anything flow. Why? What might be missing here?
Solution found: Writing for anyone experiencing the same problem.
Be extra careful which field you are trying to select and the requirements that Oracle has for selecting it. In my case I was missing the single quotations only.
FAKTURA table fakturanr I can select with SELECT * FROM faktura WHERE fakturanr=111111
AOPKOPF table belegnummer I cannot select the same way. I needed to do SELECT * FROM aopkopf WHERE belegnummer='111111'
I had to change the logic a bit but here is the working solution (there are '' for the variable):