Answered

Read from one excel file and write into another

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

v-monli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No