Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Jyotisha Gupta]

Hi,

I’m working on canvas app. In my app I have a table (via SQL Server connection), contains multiple projects records for multiple months (suppose Project A has Jan2020 to Apr2020, Project B has from nov2009 to Feb 2010, Project C from Feb 2011 to Jun 2011). Once the user selects project A he/she can see Jan 2020 to Apr2020 records of various fields in table. And by using clearcollect I’m collecting output in “queryresults” on the basis of project and Month year selection and getting values from queryresults in below all 17 textinputs(mentioned in first image in attachment).
For entering new month and user need to select Month yr from another dropdown which shows further months.Month Year is separate table (Varchar) in SQL server table. We have one more new table for adding new month record, second image in attachment.  In this new table only basic details are provided, rest editable fields are blank.  

so once the user select the month year and clicks on OK button all the txtinput fields mentioned in above image need to be updated and one new month record need to add in existing record. 

Kindly suggest what to write in OK button Onselect  or some other suggestion.

—

Thanks & Regards: 

Jyotisha Gupta

+91-9555246139

jyotishagupta13@gmail.com 

[Mariano Gomez Bent]

At first when I read your post, I was inclined to suggest you use the Patch() function to patch the records through, but upon understanding the complexity of what you are doing, I would be more inclined to have that button call a flow and pass the parameters you need to that flow, then use the Execute Stored Procedure action to call a stored procedure that will do all the updates and insert the new record for you. 

In turn, your stored proc can return a status value to your flow to relay it back to your app, so you can refresh the window with the updated values and new records.

——————————
Mariano Gomez Bent
Director of Technology
Mekorma
ROSWELL GA
888-635-6762 Ext 547
——————————
——————————————-