Store a list in a single SharePoint List Entry

Ayden Franklin 40 Reputation points
2024-06-18T15:18:34.8166667+00:00

I am currently building a Ride scheduling power app. Users can log into the app and schedule a ride using the company car and then join rides. I am storing information regarding each scheduled ride in a SharePoint list.

I want to store a fixed sized list of all users who have joined that specific ride, but I do not know how to store a list in a single entry of a record.

What is the best strategy to do this?

Thanks.

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,227 questions
0 comments No comments
{count} votes

Accepted answer
  1. Yanli Jiang - MSFT 23,661 Reputation points Microsoft Vendor
    2024-06-21T02:11:18.4866667+00:00

    Hi @Ayden Franklin ,

    I'm sorry that I didn't understand your requirements correctly. According to your description, this cannot be achieved directly in SharePoint and is more related to Power Apps. But unfortunately, Power Apps is currently not supported in the Q&A forum. In order to better solve the issue, we suggest you start a new discussion via the Power Apps Community so that you can get dedicated support on this issue.

    Thanks for your understanding!


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Yanli Jiang - MSFT 23,661 Reputation points Microsoft Vendor
    2024-06-19T02:47:58.6933333+00:00

    Hi @Ayden Franklin ,

    Welcome to Q&A forum!

    As a SharePoint engineer, we recommend that you do the following:

    To store a fixed sized list of all users who have joined a specific ride in a SharePoint list, you can create a new column in the ride schedule list and set the column type to "Person or Group". This will allow you to select multiple users for each ride. You can then use Power Apps to display this list of users in your app.

    Reference:

    https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/sharepoint-scenario-setup#set-up-lists-for-sharepoint-online-integration-with-power-apps-power-automate-and-power-bi


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.