Answered

Variable Data not transfered to sharepoint Lookup column from Power apps

(0) Share

Report

Posted on by Strongestfen

Hello all,

I am trying to build some small scale project management app in Powerapps. The logic - Project -> Sub-Project -> Task.

I am currently stucked with task level. Each task has relation to project portfolio sharepoint list and sub-project portolio list through Lookup column.

I wanted to automatically populate form field with this Project and Sub-Project info when a new task is created using this approach .
Project Info:
{
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference";
ID: varcurrentItem.ID;
Value: varcurrentItem.ProjectName
}

Sub-project Info:
{
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference";
ID: varsubprojectItem.ID;
Value: varsubprojectItem.Title
}

Expected values are correctly visible in the fields but when submit the form, it doesnt transfer the values to sharepoint list. However row in sharepoint list is created and highlighting that info is expected.

During my testing I noticed that if I reselect the values from dropdown manually and submit the form, the values are transfered as expected.

I will be very glad for ideas how to ensure that default values (project and sub-project info) are sent to my sharepoint list.

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Sort by

BCBuizer 22,833 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Strongestfen ,

Can you please share the Items properties of the DataCardValues (the combobox where you select the value)?

Was this reply helpful? Yes No
Strongestfen 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Dropdown with project info: Choices([@ProjectTaskList].ProjectListLookupTask)
Dropdown with sub-project info: Choices([@ProjectTaskList].SUbprojectLookupTask)

Was this reply helpful? Yes No
Verified answer

BCBuizer 22,833 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Strongestfen ,

Try setting the DefaultSelectedItems property for project to:

Coalesce( Parent.Default, LookUp( Choices([@ProjectTaskList].ProjectListLookupTask), Value = varcurrentItem.ProjectName ) )

and for sub-project to:

Coalesce( Parent.Default, LookUp( Choices([@ProjectTaskList].SUbprojectLookupTask), Value = varsubprojectItem.Title ) )

Was this reply helpful? Yes No
Talha_Dar 870 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Strongestfen,

Simply assign the desired value to the Default property. To add a value in the Default property of your dropdown,

If you found my answer helpful, please consider giving it a thumbs-up or a like. Your feedback is greatly appreciated!
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Strongestfen 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @BCBuizer

(my comment is valid for project and also sub-project).

I kept this in form card default:

'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference";
ID: varcurrentItem.ID;
Value: varcurrentItem.ProjectName
}

And added bellow to DefautlSelectedItems of dropdown Datacard value:
Coalesce( Parent.Default; LookUp( Choices([@ProjectTaskList].ProjectListLookupTask); Value = varcurrentItem.ProjectName ) )

However, I haven't any change. When I submit the form, data are not transfered to sharepoint list (lookup column).

Was this reply helpful? Yes No
Strongestfen 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

I am sorry but I am not so experienced, yet. The default value should change based on which project / sub-project is selected, so the value is changing.

How do you recommend to fix my challenge?

Was this reply helpful? Yes No
Talha_Dar 870 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Strongestfen,

Sure, here are the instructions to set the Items property and Default property for the dropdowns:

For the "Dropdown with project info," set the Items property to:
Choices([@ProjectTaskList].ProjectListLookupTask)
This will populate the dropdown options with the choices from the "ProjectListLookupTask" column in the "ProjectTaskList" data source.

For the "Dropdown with sub-project info," set the Items property to:
Choices([@ProjectTaskList].SubprojectLookupTask)
This will populate the dropdown options with the choices from the "SubprojectLookupTask" column in the "ProjectTaskList" data source.

For both dropdowns, set the Default property to the value that should be saved to SharePoint if no value is selected in the dropdown.

If you found my answer helpful, please consider giving it a thumbs-up or a like. Your feedback is greatly appreciated!
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Strongestfen 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Talha_Dar ,

I have this in Default for dropdowns:

Project Info:
{
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference";
ID: varcurrentItem.ID;
Value: varcurrentItem.ProjectName
}

Sub-project Info:
{
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference";
ID: varsubprojectItem.ID;
Value: varsubprojectItem.Title
}

Items are set up as you recommended for both dropdowns.
Still the values are not passed to sharepoint list.

Was this reply helpful? Yes No
Talha_Dar 870 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Strongestfen,

Can you please explain the content of the "varcurrentItem" variable, and clarify whether you want to use the default values defined in this record for the Project and Sub-Project fields, or if there is another relationship between these fields?

Was this reply helpful? Yes No