Hello Experts , I am new to power apps and building an app. my App is combination of two data source SQL and share point. some field fetch data from SQL and store in share point. As of now i have created one share point list with all the column i required.
i want both type of field (fetching data from SQL and text input field) on the same form and after filling the form on submit button record should submit to the share point list. let me explain more by below example.
I have created one share point list and from that list power app is created at this moment data source for this form is share point list and whatever i will enter in text field it will store in respected list column,. i have 3 fields here name , Activity plan, Activity Phase and Activity Type these field i wan to fetch value from SQL with in the same form. as per my experience filed level data source we can not assign. these filed will be drop down field and user will chose value and that selected value should store in share point list. in share point i have created these 3 column as choice type.
I am thinking of adding a dropdown input and link it to sql but in the same form i am not able to add dropdown input. i am avoiding creating a new form on the same screen.
please advise how can i achieve this.
Thank you
