
Announcements
Hi all,
I have a SQL table (dbo.Sales) which contains 5 columns, one of which is “Store”
Store |
Store677 |
Store123 |
I want to create a form, where I can pull all store data from dbo.Sales, column “Store”, and to see it as a dropdown menu. After that I want to add to the same form, a date calendar next to the selected store. After this I want to submit the form/information to a new SQL table (dbo.Sales2)
I would appreciate your help if this is possible and how I could create it.
Thank you.
Hi @User991 ,
Seems you are want to use the editable gallery to update the data source, please refer to below videos:
https://www.youtube.com/watch?v=mj4mKS1hS7M
https://www.youtube.com/watch?v=8I0Pt_8I6k8
https://www.youtube.com/watch?v=wI6SHGQ9ATg
https://www.youtube.com/watch?v=xgznk4XlPCo
Tutorial doc:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/add-editable-tables
Hope this helps.
Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.