Choice show in powerapps

(0) Share

Report

Posted on by nitisak

162

Hi Hi Hi.

I've a question, If i would like to show selected choice that recorded in SP list to PowerApps gallery. How can I do.

I've 3 choices in my choice 1.Leave 2.WFH 3.Event

EX. I want to show only selected Leave in gallery

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Sort by

AARON_C 2,235 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @nitisak,

To filter the gallery to just show the records that have selected "Leave":

Filter(Collection/Table Name, 'Column Name'.Value = "Leave")

Please tick Accept as solution if the answer is useful.
Thanks,
@AARON_C

Was this reply helpful? Yes No
nitisak 162 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @AARON_C

This is an error that I founded.

Was this reply helpful? Yes No
AARON_C 2,235 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@nitisak

Did you put this formula in the Items property of the gallery?

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @nitisak ,

Each record includes different selected choice, and you need to define which record it is. Besides, Gallery control usually be used for displaying multiple items of a table. May I know why you need to display a single choice in Gallery?

Best regards,

Was this reply helpful? Yes No
nitisak 162 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-jefferni
I create Calendar app and try to separate calendar view between WFH and Leave. Now I'm stuck on view with only WFH and Leave.

I would like one calendar show only WFH choice that has selected from user (That I stored result in SP) and another show only Leave.

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @nitisak ,

Then as @AARON_C said, you need to put the formula in Items property of the Gallery to display all WFH items. For more clarity, could you please share your app screen in a screenshot in case we misunderstand?

Best regards,

Was this reply helpful? Yes No
nitisak 162 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-jefferni @AARON_C
Sure. I have insert label under gallery to show the data that I would like.

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @nitisak ,

Ok, then you need to add a condition in the Filter function:

Filter( Calendar, Status.Value = "WFH", StartDate = ThisItem.Value || SecondDate = ThisItem.Value || ThirdDate = ThisItem.Value )

Best regards,

Was this reply helpful? Yes No
nitisak 162 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-jefferni

Thank you now it works.

Was this reply helpful? Yes No