web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Combine two formulas

Power Apps

Answered

Combine two formulas

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Guys,

can you help me combine this two formulas for items property.

1. filter([@‘lists and projecten’]. Projectnumber; projectnumber. Value = dashboard.gallery.selected.projectnumber)

2. choices(‘list and projecten’.listnumber’)

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
can you please try using below formula-
Filter([@‘lists and projecten’]; ProjectNumber.Value = dashboardGalleryName.Selected.ProjectNumber; ListNumber.Value)

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

Like
a
(0)

Report
Copy link

Link copied!

Hi @NandiniBhagya20, thanks for your reply.

I tried it but it did not work. The combobox is just empty.

I should have mentioned i am using this in a combobox to give choices of ‘Listnumbers’ in records where the projectnumber = dashboard. Selected.projectnumber.

Was this reply helpful? Yes No
Verified answer

v-liwei-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

You can try modifying the formula to:

filter([@‘lists and projecten’],projectnumber. Value = dashboard.gallery.selected.projectnumber).listnumber

Best Regards,
Levi

Was this reply helpful? Yes No

Join the conversation