Power Platform Community Forum Thread Details

Hello,

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:

General Questions