If statement to dropdown

[akbarmahfuzalam]

Hello Team,

I need help in the below formula as I am trying to fix it but I am getting no value and an error.

If(ddAuditor.Text= UploadeBY,Distinct(Filter(ProcessKnowledgeTest,Team_Lead=ddAuditor.Text),Team_Lead))

I have SharePoint List ProcessKnowledgeTest and have a column named as Team_Lead and a column name UploadedBy.

What I want here in the dropdown list as when the UploadedBy column updated in the Powerapps it gives the dropdown related to Team_Lead 

The dropdown here named as  = ddTL_PKT

[RandyHayes]

@akbarmahfuzalam 

Not sure that I am entirely following your logic for the problem you're having, but you might want to consider this formula instead:

Distinct(
    Filter(ProcessKnowledgeTest,
           Team_Lead=ddAuditor.Text && UploadeBY=ddAuditor.Text
          ),
    Team_Lead
)

See if that is helpful for you.

[akbarmahfuzalam]

Hey Randy,

How are you today.

I tried using your formula but it's fetching me an error. 

As invalid argument Type

[RandyHayes]

@akbarmahfuzalam 

What kind of column is UploadeBY ?  And is that the correct spelling?

If the column is Text, then check the spelling.  If it is another complex type of column then you will need to reference the value of that column (in many cases UploadeBY.Value - but not always depending on the column).

[akbarmahfuzalam]

@RandyHayes 

I am trying to achieve here if my ddAuditor which is a Text input have some value which is the name of the auditor which I named it in SharePoint as UploadedBy, I need to populate all the Team_Lead which is associated with Created By.

Example of SP

[RandyHayes]

@akbarmahfuzalam 

Okay, then you had a spelling issue on the formula I gave you.  If in fact, the column is called "UploadedBy" then change the formula to have that, not "UploadeBY"

And still the question is, is UploadedBy a text column, or is is a person column?

[akbarmahfuzalam]

@RandyHayes,

Sorry , it is Created By and not UploadedBy.

When I use the same formula. It's not happening

SP List

Sorry. It is created by

[RandyHayes]

@akbarmahfuzalam 

CreatedBy is a complex column type.  It is a Person.  You will need to reference it as such.  I assume it is the Full Display Name of the person that you have in your ddAuditor text.

In that case you need:

Distinct(
    Filter(ProcessKnowledgeTest,
           Team_Lead=ddAuditor.Text && 'Created By'.DisplayName=ddAuditor.Text
          ),
    Team_Lead
)

[akbarmahfuzalam]

@RandyHayes ,

In the dropdown, it is not showing anything. All are blank when I Click the dropdown.

[RandyHayes]

@akbarmahfuzalam 

Please look at the list settings for your list - what kind of column is "Team_Lead"?  Is it a text or a person column?