Forum Discussion
moemaya
Feb 11, 2019Copper Contributor
Repeating Macro until I get an empty row
Hi totally new to macros, but i figured out how to record one and it works. Now I need to make it repeat for several rows until it gets to an empty row. see below Sub Macro5() Range("P9").GoalSee...
- Jul 18, 2023
Jovi-365 Correct. This is your SharePoint list URL where you have Power Apps customized list form and where you must be storing the form data:
https://<tenantName>.sharepoint.com/sites/<siteName>/Lists/Trade Requests/Open Trade Requests.aspx
Open Trade Requests is the name of your list view which is set as default view in your list.
If you want to access all items/records in the list, you can try this URL:
https://<tenantName>.sharepoint.com/sites/<siteName>/Lists/Trade Requests/AllItems.aspx
AllItems is the SharePoint default view created when you create a new list. It should be available for you unless someone else deleted it.
If you want to set the All items view as default, open the respective view & follow steps in my answer at: How to set a view of a Microsoft List as the default view
Related documentation for list views: Create, change, or delete a view of a list or library
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
william97296
Feb 12, 2019Copper Contributor
Do you have a sample spreadsheet?
- moemayaFeb 12, 2019Copper Contributor
See attached