If statement to dropdown

(0) Share

Report

Posted on by akbarmahfuzalam

709

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

Categories:

Building Power Apps

I have the same question (0)

All responses (13)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@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.

Was this reply helpful? Yes No
akbarmahfuzalam 709 on at

Like (0)

Report
Copy link

Link copied!

Hey Randy,
How are you today.

I tried using your formula but it's fetching me an error.
As invalid argument Type

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@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).

Was this reply helpful? Yes No
akbarmahfuzalam 709 on at

Like (0)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@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?

Was this reply helpful? Yes No
akbarmahfuzalam 709 on at

Like (0)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@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 )

Was this reply helpful? Yes No
akbarmahfuzalam 709 on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes ,

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

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@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?

Was this reply helpful? Yes No
akbarmahfuzalam 709 on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes ,

It is a single line Text

Was this reply helpful? Yes No