Formula of Multiple and Text Input for Person

(0) Share

Report

Posted on by asuhaimi

Hello Guys,

Below my current Gallery->Items formula.

If(FilterTheList,Filter('CSA 2022 STANDBY LIST','WEEK 2022'.Value = "WEEK " & varWeekNumber),'CSA 2022 STANDBY LIST')

If I want to insert 1 dropdown with Column naming WEEK 2022 (Choice) and 1 TextInput with column naming PIC (Person Or Group). How the formula on my Gallery Items should be?

Thanks for your help

Regards

asuhaimi

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

asuhaimi 85 on at

Like
a
(0)

Report
Copy link

Link copied!

Additional.. I need the PIC as DisplayName
v-xiaochen-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @asuhaimi ,

I did a sample for you.

1\ Dropdown Items:

Choices(LIST217._Choice)

2\ Gallery Items:

Filter(LIST217,_Choice.Value=Dropdown1.Selected.Value,_Person.DisplayName=TextInput1.Text)

Result:

Best Regards,

Wearsky
asuhaimi 85 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-xiaochen-msft

Thanks for your response. Unfortunately its not work if i joined into my formula