cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Update task list in Sharepoint through PowerApps

I am trying to find a way to either update an excel list in Sharepoint or a custom list in Sharepoint with information from PowerApps.  The PowerApps App will be ran on multiple devices and I am having difficulty identifying a flow that would allow me to update the list in Sharepoint everytime I click the OK button at the bottom of the PowerApps.  Any advice would be greatly appreciated.

 

There will be no need to update any already stored items.  If a need is required it will be done in Sharepoint by the individual.  This will strictly be used to add new items into Sharepoint.

 

Example is provided below.

 

PowerApps on IPad:

  1. Fill out Box1 & Box2
  2. Click 'OK'

 

Microsoft Flow

  1. Store Data from Box1 & Box2
  2. Open Sharepoint and find the custom list or excel sheet
  3. Find the first blank row in the custom list
  4. add information from Box1 into column A and from Box2 into column B of the first blank row

PowerApps:

  1. Clear Box1 & Box2

Thank you everyone for your help.  If you need further explanation I will try my best to be able to provide it.

 

1 REPLY 1
Highlighted
Community Support
Community Support

Hi @malekedward,

 

We are able to update a SharePoint custom list from PowerApps, but I am afraid that it is not possible currently update an Excel in SharePoint.


Have you created an app based on the custom list in SharePoint?


On the app, there should be an EditForm for you to update newly added data from the app to the list.


I assume that this doc on PowerApps forms could be a reference for you:
https://docs.microsoft.com/en-us/powerapps/working-with-forms

 

About your scenario on Flow, I am not sure with that. What do you want to achieve by using Flow?

 

If possible, please show me more info to help better understanding your scenario.


Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (7,137)