Forum Discussion
SharePoint list
Hello Community - Looking for guidance on a problem. Appreciate any suggestions. We have an Excel spreadhseet in SharePoint that receives input from 20 users. Sort of a project tracking shee...
One option would be to use Business Connectivity Services to create an External Content Type, this would pull in the data as Reference list and you could connect that to another list to enter in any new data.
Another option would be to use FLow to get the data and a Power Apps form to enter new data (from a mobile device if appropriate)
You may also want to consider using a Related Items column, Benjamin Niaulin has an example at https://en.share-gate.com/blog/new-sharepoint-2013-column-related-items
Just wanted to say thank you for the replies. Once we figure it out I will update.
Any changes or ideas ? Right now Im thinking about SPonline with SAP integration and some tips would be usefull :)
