Answered

Dropdown Value

(0) Share

Report

Posted on by rohitsekar1996

Hi guys,

I have been trying to create a user form . I have two drop down fields named Portfolio_level and portfolio_input were portfolio_level has items called ["Country","Region","Global"] . I am suppose to the get the values from a share point list REGION_COUNTRY when i choose any item from portfolio_level. For eg - if i choose region from portfolio_level i need to get all the region from the share point list(REGION_COUNTRY) and displayed as drop down in portfolio_input

When i try to do the same thing i get below error in update.

PIC 1PIC 2

Categories:

Building Power Apps

All responses (6)

Answers (2)

Sort by

Joel CustomerEffective 3,224 on at

Like
a
(0)

Report
Copy link

Link copied!

Looking at your formula, you are not setting the items correctly. Your if statement is right, but after If(Datacard.....Selected.Value=Country,

It should be Filter(Region_Country,Country=X,Region)

(assuming you want to filter to the region country records where the country is a certain country and display those regions
rohitsekar1996 58 on at

Like
a
(0)

Report
Copy link

Link copied!

thanks for the suggestion, but i do not want my region to populate based on the country selection. I just need my country and region values from share point to be populated in the portfolio_input field when i choose the region from the portfolio_level and the same of country . so for example if i select the country from the portfolio_level field i need all country to be populated from share point list
Joel CustomerEffective 3,224 on at

Like
a
(0)

Report
Copy link

Link copied!

just giving you a suggestion to get past the 2,000 item delegation limit. Your approach would work as long as it doesn't go over 2,000 records.
Verified answer

v-siky-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @rohitsekar1996 ,

I just want to confirm what's data type of portfolio_input column in sharepoint? Is it single line of text type?

If so, what you need to modify is to unify the two column names as the drop-down field only recognizes one column name.

Try to modify the Items property as follows.

If(DataCardValue3.Selected.Value="Country",RenameColumns(REGION_COUNTRY.COUNTRY_DISPLAY,"COUNTRY_DISPLAY","Value"),RenameColumns(REGION_COUNTRY.REGION,"REGION","Value"))

Then set the Update property as follows.

DataCardValue4.Selected.Value

Hope this helps.

Sik
rohitsekar1996 58 on at

Like
a
(0)

Report
Copy link

Link copied!

thanks for you answer works perfectly ,Is there anyway to apply distinct function in the if condition since region,country contain some duplicate values.
Verified answer

v-siky-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @rohitsekar1996 ,

Of course, Distinct() function returns Result, unifying the column names at the same time.

Try to modify the Items property of Dropdown as follows.

If( DataCardValue3.Selected.Value="Country", Distinct(REGION_COUNTRY,COUNTRY_DISPLAY), Distinct(REGION_COUNTRY,REGION) )

Then set the Update property as follows.

DataCardValue4.Selected.Result

Hope this helps.

Sik