I have created a powerapp form using a table from an Oracle database and I am trying to create the following and I am experiencing some diffuculties:
For #1 - set the default property of the text control to dropdown.Selected.ID gives ID
#2 - return the primary key value from stored procedure to powerapps
You need to configure MS Flow to call stored procedure, once data is successfully inserted, return the primary key to MS flow which in turn will pass back to powerapps.
Alternative to #3-#4: Create a view to get the sequence number from dual table and onChange of ddWELLNAME, write below code
set the default value property of PA_WELL_HDR_S to SEQNO
Hi Good Day,
I am very grateful for your assistance. The automatic population of the sequence when the well name is changed is working now.
I am now getting the following error on the Well_name drop down. - The Update is not working when I select the well name. The selected well name is not saving in the table upon insertion. I am seeing the other field items but the well name column is blank.
I did the following:
On the well name drow down:
1. OnTimerEnd - Refresh('[APPOWER].[VW_PA_WELL_HDR_TR]')
2. Duration:10000, Set Repeat : On, Auto Start : On, Visible: Off
On the PA_WELL_HDR_S test input:
• OnChange: SEQNO
• Set default: SEQNO
Continue your learning in our online communities.
Features releasing from October 2019 through March 2020
Coming to a city near you
Fill out a quick form to claim your user group badge now!
Connect, share, and learn with your peers year-round
Register by September 5 to save $200