cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Read from one excel file and write into another

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Anonymous
Not applicable

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),{TitleSmiley Very HappyataCardValue1.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

View solution in original post

2 REPLIES 2
Highlighted
Community Support
Community Support

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

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Anonymous
Not applicable

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),{TitleSmiley Very HappyataCardValue1.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

View solution in original post

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Top Solution Authors
Top Kudoed Authors
Users online (8,401)