Submitting Form data to an excel file

[biuser99]

Hello experts,

I have designed a Form using an excel file from Onedrive. After entering the details and submitting the form it has to create a new record in a different excel file. Please let me know how to accomplish the above task.

Thank You

[cds]

Flow

[biuser99]

Thanks for the reply. Can we achieve this in powerapps itself?

[cds]

I don't think it is possible

[v-monli-msft · Accepted solution]

Hi @biuser99 ,

This can be achieved by using a Patch function. First you need to add the table in the 2nd excel file to the data source of this app. Then use the 1st table as the data source of the edit form but set the OnSelect property of the submit button to something like:

Patch(Table2,Defaults(Table2),{Title:DataCardValue1.Text,Date:DataCardValue2.SelectedDate,...})

Regards,

Mona 

[biuser99 · Accepted solution]

Thank You Mona.