using data from excel to add a row with Microsoft flows on power apps

[Ire]

I've created a flow to add a row in excel using power apps. I've created a new screen(forms screen) in power apps, connected it to my excel table and selected the fields for what I want to input. When I go to actions and click on power automate and then select the flow I want, it says complete the flows' parameters in the formula bar and I do not know what to do. I don't know if I'm meant to declare the variables of what I want to input OR maybe I don't even have to use flow at all and just use the submit form button and it will automatically update my excel table.

[v-litu-msft · Accepted solution]

Hi @Ire,

You could approach that via Power Automate or Power Apps, but Power Apps will be more convenient.

Here are documents you could refer to how to create a record and submit it to data source:

Display form and Edit form controls: reference - Power Apps | Microsoft Docs

EditForm, NewForm, SubmitForm, ResetForm, And ViewForm functions - Power Apps | Microsoft Docs

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.