You’re offline. This is a read only version of the page.
I have a SharePoint list and i want to create a canvas app based on the list, The problem is there might be multiple values to a column. I wanted to check how can i achieve that.
Example -
SharePoint list structure -
Project Number - Auto populated using a flow.
Project Name - Text Value
Description - Multi Lines of text
Project Target - Multi Lines of Text.
Stake Holders Information - ?
Now when entering the details i want to provide for Stake Holder information with 3 data (Stake Holder Name, Activity and Responsibility). There can be one stake holder or more than 1 stake holder.
How can i achieve this on PowerApps. I have seen few app where Add option is given with the Headers (Stake Holder Name, Activity and Responsibility) and they can enter multiple values for the same. How is the data stored with multiple values for a column for the same row.
Thanks
Please watch the tutorials. I am also adding below tutorials from Dan Christain which can be exactly what you are looking for.
SharePoint List Relationships Part 1
SharePoint List Relationships Part 2
SharePoint List Relationships Part 3
SharePoint List Relationships Part 4
Thanks and Regards,
Ramesh Mukka
I just tried to replicate what i need in a word document.
i need something similar where users can see a + symbol to add a new entry. But in the backend how should i configure SharePoint list to store this information
@sameer0411 You can use editable grid like gallery with the help of collection to enter multiple rows of data for a given project.
One of the tutorials from Reza on such use case: https://www.youtube.com/watch?v=P6yqIpjmPrs&list=PLTyFh-qDKAiHeIy4xwTFpz_03poNzPuQU&index=5&ab_channel=RezaDorrani
You can also watch several such tutorials from Reza through this playlist.
https://www.youtube.com/playlist?list=PLTyFh-qDKAiHeIy4xwTFpz_03poNzPuQU
Please invest sometime in learning these several techniques. You'll not regret
Thanks
Ramesh
@RameshMukka Thanks for your reply. But i still don't understand how the data is entered and stored in SharePoint.
It will be multiple values for the same row, Users will enter the data for stake holders. and this information will be for one project. Multiple values for stake holders... how to achieve that.
You can use another SharePoint list for stakeholder information. That will be the secondary list and other list will be the primary list. The ID of the primary list can be referenced in the secondary list as a reference ID to create a relationship between 2 lists. You can use functions like LookUp and Filter whenever you'd like to refer one list from other through Canvas Apps. Hope that helps.
Thanks,
Ramesh Mukka
Share
Report
21
All responses (
Answers (