Display items from one list and send them to another (avoid hard coding)

(0) Share

Report

Posted on by levoncosta

Hello,

I have this issue where I am looking to show results from a column in a SharePoint list.

This is the Items property of AdminTaskCategoryDDL:

Sort
(
 Table
 (
 {Item: " "},
 {Item: "Installation (HW/SW)"},
 {Item: "Configure/Construct"},
 {Item: "Design/Discovery"},
 {Item: "Data Conversion"},
 {Item: "Testing/Validation"},
 {Item: "Training"}
 ),
 Item
)

These are specifically pulling from a list called 'Project Time Tracking'. I want the AdminTaskCategoryDDL to display items from 'Task Category' list. The form, which houses AdminTaskCategoryDDL, is meant to submit the choices to 'Project Time Tracking' to populate its columns. How do I achieve all this without hard cording the items like you see in the table?

Many thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @levoncosta，

Let me confirm with you:

1). You want to popualte the AdminTaskCategoryDDL with another list named 'Task Category'

2). Submit the choices to your data source, 'Project Time Tracking'

Could you please tell me that if the column where you saves the choices in 'Project Time Tracking' is a Choice or a LookUp or a Text type?

If the column from 'Task Category' is a Text type, I think you could directly make the column where you saves the choices in 'Project Time Tracking' a LookUp type. Therefore, you could set the Items property of AdminTaskCategoryDDL with Choices('Project Time Tracking'.Column), it will display all the choices from the column in 'Task Category'.

Here is the detailed blog:

Create list relationships by using lookup columns - Microsoft Support

Was this reply helpful? Yes No
levoncosta on at

Like (0)

Report
Copy link

Link copied!
@v-qiaqi-msft
Yes, the first 2 points are correct.

The Task Category column of the Project Time Tracking list is a single line of text column.
The TaskCategoryName column of the Task Category list is also a single line of text column.

I think when you say "Therefore, you could set the Items property of AdminTaskCategoryDDL with Choices('Project Time Tracking'.Column), it will display all the choices from the column in 'Task Category'", what you meant to say was grab the choices of the TaskCategoryName column of the Task Category list?

So, the Items property for AdminTaskCategoryDDL would be:

Choices('Task Category'.TaskCategoryName)

Keep in mind, the DataSource property of this InputScreenAdminForm is:
[@'Project Time Tracking']

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @levoncosta,

There is a necessary prerequisite before the "Therefore", which is that you must make Task Category column of the Project Time Tracking list a LookUp type column. So I provided a detailed blog for reference to how you create a LookUp column in SharePoint list.

1). Make the Task Category a LookUp type in column settings, then it will require you to select which list you want to retrieve the choices from, where you should select the Task Category list, and then you select the TaskCategoryName column from the columns dropdown list.

2). Save the settings and you could find that you ccould select choices from the Task Category column of the Project Time Tracking

This is the most efficient way to achieve this, otherwise we need to do a lot of work to write expressions to capture choices from Task Category list and update it.

Anyway, if this is not convenient for you, just set the Items property of AdminTaskCategoryDDL:

Distinct(TaskCategoryList,TaskCategoryName)

The following is optional.

Set the DefaultSelectedItems property of the Combo Box as below:

Filter(Distinct(TaskCategoryList,TaskCategoryName),Result=ThisItem.TaskCategory)

Set the Update of the data card:

AdminTaskCategoryDDL.Selected.Result

Was this reply helpful? Yes No