Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

PowerApp - Community Resources App questions

Posted on 21 Nov 2024 20:03:29 by 2
Hi all, 
 
I appreciate any direction on this and thanks for reading! I am going to be as concise yet detailed as possible; I've been working on this awhile and getting absolutely stuck. 
 
Use-Case: Users in the field will be accessing my PowerApp via mobile or iPad. They want a way to access and easily share Community Resources with clients in the field on the fly. I want the app to allow for single or multi-selections from the Gallery results and then have the ability to export those selected results and key columns from the SharePoint list, such as Email, Location, etc., into a shareable format such as excel or CSV. 
 
 
SharePoint list: "Community Resources" 
Gallery: CommResourcesGallery
Search Box (a Text Input control so users can type to filter items): "SearchBox"
Gallery.Items = Search('Community Resources', SearchBox.Text,Name)
 
 
Columns in my SharePoint list: 
Column Friendly Name
SP List Column Name
Column Type
Organization
Title
Single line of text
Description
field_1
Multi-lines of text
Category
field_3
Choice
Location
field_4
Choice
Website
field_5
Single line of text
Phone
field_6
Single line of text
Email
field_7
Single line of text
 
I have a Check Box icon as part of the gallery that changes color when it's selected in order to indicate to the user that they've selected it. 
OnSelect code for CheckBox: 
 
 
 
OnSelect code for ExportButton:
 
 
...Which is producing a syntax related error: 
 
I may be way off in my approach; I really pieced this together through a lot of rabbit holes. Happy to accept any direction! 
 
Intended result: Directly from the app, export an excel file that would look like the following (assuming the user only selected these two results): 
 
 
I know based on my explanation, I don't have some, or lots, of the right code in place, but figured I'd share exactly what I want this to be once completed. 
 
Issues/Questions in no particular order -- 
 
  1. How can I have SearchBox look at a choice column called "Tags" and the Title and Description columns from my SharePoint list?
  2. When I select any checkmark, it selects ALL check marks. How do I have it just change colors of the one I am selecting? 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

October 2024 Newsletter…

October 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #4 How to Conntact Support…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,061

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,795

Leaderboard