Filter (Showing on input filed)

[rbalza]

Hi everyone, I am new to using power apps and I would say, it is awesome! I am trying to show text on the input field when multiple filters have been applied. I am using lists as a data source and  the standard invoice description has a predefined text to it. Could someone help me out on this, please? Code for each filter below.

Job Category Filter

Distinct('Source','Job Category')

Entity Type

Distinct(Filter('Source','Job Category'=DataCardValue31.Selected.Result),'Entity Type')

Job Type

Distinct(Filter('Source','Job Category'=DataCardValue31.Selected.Result && 'Entity Type'=DataCardValue39.Selected.Result),'Job Type')

Sharepoint list as data source

[BCLS776]

It sounds to me like you want to combine the selections from the three dropdowns to fill the label, right?

Assuming they are dropdowns (comboboxes behave differently), try the following code in the Text property of the label:

DataCardValue31.Selected.Result && " " && DataCardValue39.Selected.Result && " " && DataCardValue40.Selected.Result

Not sure about the control name for the third dropdown, so edit that as necessary.

Hope that helps,

Bryan

[rbalza]

Hi BCLS776, thanks for taking the time on this. Sorry for not explaining it well. There was pre-define text on the standard invoice description column coming from datasource (SharePoint list). Instead of making it like a dropdown, I wanted to be in an input field or even a text field. These dropdowns were not actually dropdown buttons instead it is a single text in which I changed the type into allowed values (not sure what is the difference between the two though).

[BCLS776 · Accepted solution]

Ah, I think you are trying to look up that Standard Invoice description from the list that corresponds to the selected Job Category, Entity Type, and Job Type, right?

If so, try putting the following into the Default property of that field:

LookUp('Source',
    DataCardValue31.Selected.Result in 'Job Category' &&
    DataCardValue39.Selected.Result in 'Entity Type' &&
    DataCardValue40.Selected.Result in 'Job Type',
    'Standard Invoice Description'
)

That will put the standard contents in there to start, which can be edited before the form is submitted.

[rbalza]

You are a gift from above 🙂 Thanks for the solution! By chance, do you have a tutorial that you've wanted to promote? As I would definitely support it!

[BCLS776]

Glad to hear that helped! I have no online tutorials to share at this point; I'm simply giving some of my time to a community that has helped me out with my Power Apps glitches. I hope you'll do the same as your knowledge grows.

Bryan