Share
Report
32Hello,
quite new to canvas apps.
I am building a Power Apps app that connects to a SharePoint list with around 100 columns.
Users should select a 'Resource Name', and fields with values only should be displayed.
Additionally, a specific user should be able to add columns/deals in the app (which in turn will be added in SP) and those columns should be visible and editable for the other users.
Some columns might have missing data (empty cells) for certain resources.
quick example of the sp structure below:
| Manager | Resource Name | Deal1 | Deal2 | Deal3 | Deal4 | Deal5 |
|---|---|---|---|---|---|---|
| John Smith | Alice Johnson | 50 | 50% | |||
| John Smith | Bob Brown | 75% | 15% | |||
| Mary Davis | Charlie Green | 50 | 50 | |||
| Mary Davis | Dana White | 100% | ||||
| John Smith | Eve Black | 25% | 25% | 25% | 25% |
- The goal is to show only the columns with values when a specific
Resource Name is selected in Power Apps. Other columns (e.g., empty deal columns) should be available in a ComboBox for the user to select and display if needed.My questions is - what would be the best approach having in mind functionality and user experience to meet the above mentioned needs
I’ve tried using a Gallery for the Resource Name and a separate Form for the Deals. However, I’m struggling with how to conditionally show only the DataCards with values and manage the dynamic addition of new columns in the Form. Additionally, I experimented with transposing the deals into rows to utilize the Gallery control, but this approach complicates the monthly export of the SharePoint list, which needs to retain its original column structure.
Any suggestions are much appreciated.
thank you
Martin
Categories:
I have the same question (0)
All responses (
Answers (
