web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Fetch a column of valu...

Power Apps

Answered

Fetch a column of values from one list(A) to another list(B) and to select one value from all values in a field/column when "New entry" created.

(0) Share

Report

Report

Posted on by Priyan1

14

I have a list of countries in List-A, which may be updated / added time to time.

I need that countries to be available as a choice field or combo box in another List-B where people are allowed to add entry (with Customize Forms) with read only permission.

What is the way to fetch country column in List-B while adding an New entry (countries to be fetched from list-A)?

Kindly guide necessary power automate steps or any other simple way.

Regards,

Priyadharthan

Categories:

Building Power Apps

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Priyan1,

Do you want to fetch countries from list A into a Combo Box?

Could you please share a bit more about your need?

Actually, if you want to display all the countries from list a, you could directly set the Items property of the Combo Box as below:

Distinct(ListA,Country)//Distinct() function return unique values from country column

Note that this function recognizes the Country as a Text type column in the ListA.

Join the conversation