Answered

Read from one excel file and write into another

Like (0) Share

Report

Posted on 16 Aug 2019 08:46:30 by Community Power Pla...

Dear all,

I am devloping an app that needs to deal with 2 files with different permissions in the same screen. I'll call the first file "User File" and the second "Admin file". The User will have read/write permissions for the User File, but only read permissions to the Admin File. The Admin will have read/write permissions for both.

Using Form1, the user will input some data into the app. This data will be written in the User File and a flow will be triggered to notify the Admin that new data is available.

Now it's when it gets tricky. The Admin will need to check this data in Form2. Form2 has the same fields as Form1 plus some more, and the fields that are common in both forms are already filled with the info input by the User. The info in those fields needs to be read from the User File. Then, the admin will complete the form with the rest of the info and submit Form 2. The data submitted in Form 2 should be written to the Admin File.

Therefore, I need a form that reads info from the User File, but then writes it into the Admin File, which I don't know how to do. Any ideas?

Thanks a lot

Categories:

General Questions

Connecting to Data

All responses (2)

Answers (1)

Verified answer

Community Power Pla... on 23 Aug 2019 at 09:38:24

Like (0)

Report
Re: Read from one excel file and write into another

Hi Mona,

Thanks for your tip (quoted here for ref)
---------------------------------------------------------------------------------------------
This can be achieved using Patch function. The formula should be something like:
Patch(Table2,Defaults(Table2),{TitleataCardValue1.Text, ...})
DataCardValue1 is the control name in Form2 with the data that you want to update to Title field of Table2.
---------------------------------------------------------------------------------------------

I managed to do it storing the contents of form1 as an Item when navigating to form2 and it seems to work, bit of a different approach with similar results.

Thanks,
carajillu_swri
v-monli-msft on 21 Aug 2019 at 09:42:27

Like (0)

Report
Re: Read from one excel file and write into another

Hi @Anonymous ,

This can be achieved using Patch function. The formula should be something like:

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

DataCardValue1 is the control name in Form2 with the data that you want to update to Title field of Table2.

Regards,

Mona