Saving data to a different data source once a status is changed

(0) Share

Report

Posted on by nleuck_101

429

Hello All,

I have a question and can't seem to find the right answer. I looked it up a few months back and thought I found what I was looking for but can't find it anymore. I'll will try to my best to explain what I'm trying to do.

I have an app where employees will enter data into a form. The active status will be set to Yes once they create a new record. This data will be saved to a SharePoint list. When they edit that record and change the active status to No, I would like the data to then move to an Excel file on our Network drive and out of SharePoint.

I feel like this is possible but need some help.

Thanks,

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Mitanshu 1,656 Moderator on at

Like (0)

Report
Copy link

Link copied!

1 - You will use a Automated cloud Flow

2 - Use trigger condition in the flow so that it only runs when Active column is No

3 - Add action to copy the data into the Excel File

4 - Add action to delete the row from SharePoint List

This question is more appropriate for Power Automate community forums.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If this post or my previous reply was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
nleuck_101 429 on at

Like (0)

Report
Copy link

Link copied!

@happyume

There might be an issue with your suggestion. I believe the actions in Power Automate only work with an online Excel document. This document would be on our internal Network drive not in a SharePoint library or OneDrive.

I posted this to Power Apps because I thought there would be a better way to patch the record to either SharePoint or Excel based on a condition.

Was this reply helpful? Yes No
nleuck_101 429 on at

Like (0)

Report
Copy link

Link copied!

Does anyone have any ideas on this? Thanks!

Was this reply helpful? Yes No