Answered

Using a text box to display output / test different functions

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I'm trying to use a text box to test different fuctions, to see what the outputs of these fuctions are.

For example, here I'm trying to see is the Filter function that I wrote works correctly. This fuction sould return true if a check box is checked next to person.

My filter function (writen in a text box) is : Filter('Gallery Users'.AllItems, 'Checkbox CheckRow'.Value)

I would like to know how to display in my text box the result of this function and the email associated to that person.

Many thanks,

Max

Categories:

Building Power Apps

I have the same question (0)

All responses (12)

Answers (1)

Ami K 15,687 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@Anonymous the Filter function will return a Table based on matching criteria. You cannot add a Table into a Label because it expects a literal string of text.

To display whether a Checkbox is checked, insert your Label control into your Gallery and then set the Text property to:

'Checkbox CheckRow'.Value

What are you ultimately trying to do?

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan

Was this reply helpful? Yes No
cdwhite 1,069 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hello,

To display 1 or multiple outputs from the gallery when the checkboxes are selected, you'd need to use the concat function:
Concat( Filter( Gallery1.AllItems, Checkbox2.Value ), emailaddress,", " )

------------------------------------------------------------------------------------------------------------------------------
If I've answered your question, please mark your post as Solved. You can accept more than one post as a solution.

If my response was a good one, please give it a Thumbs Up!

Visit my blog: https://platformsofpower.net

Was this reply helpful? Yes No
Rajkumar_M 3,747 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi

Try this formula

Concatenate( "Result: ",
If( IsEmpty(Filter('Gallery Users'.AllItems, 'Checkbox CheckRow'.Value)),
"No match found",
First(Filter('Gallery Users'.AllItems, 'Checkbox CheckRow'.Value)).Email ) )

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Amik ,

So basically, I have this share point list with users divided in different categories:

I have created a PowerApps gallery that displays these users and added checkboxes to select only certain users from this gallery :
Now, I would like to create a filter that will return / store somewhere the email of the users that are selected.
After that, I plan on creating a flow on power automate to send an email to these people.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @cdwhite

Thank you for your answer, the text box now displays the emails of users selected.

However, since the gallery to the right only displays users that are in a certain category (which is selected with the gallery to the left), the text label only displays the users selected in the current displayed gallery.
For example, if I check someone in the "Contributeur" gallery but am curretly displaying the "Admin" gallery, the text box will only show people selected in the "Admin" gallery.

Is there a way that I can display all the selected users, no matter what gallery is selected ?

Was this reply helpful? Yes No
Verified answer

Ami K 15,687 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@Anonymous ,

Another method below, assuming your People field in SharePoint is a single select field:

1. Add the Checkbox control into your Gallery
2. On the OnCheck property of the Checkbox, enter:

Collect(CollectSelection, {Email: ThisItem.'Your People Field'.Email})

3. On the UnCheck property of the Checkbox, enter:

Remove(CollectSelection, {Email:ThisItem.'Your People Field'.Email})

4. Insert another Label control outside of your Gallery. In the Text property of that Label, enter:

Concat(CollectSelection,Email & ", ")

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@Amik Thanks, that worked.

However, I have issues because I'm using two galleries :
The first one to the left to chose the category, and the second one to the right to view and select users.

I'm having issues because the checkboxes don't sync correctly. For example, if I'm in the "Admin" category and check a box, it adds the corresponding email to the text label. Now if leave the "Admin" category and go to another catergory say "Contributeur" and then come back to "Admin", the checkbox that I initially checked resets. If is check that box again, it adds the email a second time to the text label.

Was this reply helpful? Yes No
Ami K 15,687 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@Anonymous - Three solutions provided by three different people answered your question (concatenate selected Gallery items into a Label) but I think you're now asking a new question.

For me at least, I no longer understand what you're trying to do. I would suggest you "draw" an example of the result/output you need in Excel, and then paste it as an image in your response.

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@Amik

Some solutions given in this post worked on individual tests but when implemented in my app, it doesn't work as intended. I'll create a new post with more details for these specific issues and close this one.

Thanks a lot

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@Amik
Here is the new post, much clearer :
https://powerusers.microsoft.com/t5/Building-Power-Apps/Building-a-people-picker-gallery-from-ShapePoint-list/m-p/2237661#M560252

Was this reply helpful? Yes No