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

I have the same question (0)

All responses (6)

Answers (2)

Joel CustomerEffective 3,224 on at

Like (0)

Report

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

Was this reply helpful? Yes No
rohitsekar1996 58 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Joel CustomerEffective 3,224 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

v-siky-msft on at

Like (1)

Report
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

Was this reply helpful? Yes No
rohitsekar1996 58 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

v-siky-msft on at

Like (1)

Report
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

Was this reply helpful? Yes No