Selected entry in SharePoint form shows up as blank on the SharePoint list.

(1) Share

Report

Posted on by JC-25070522-0

Selected entry in SharePoint form shows up as blank on the SharePoint list.

So after filling up the SharePoint list form, everything seems to be showing up as expected, but after saving, there is one column that shows up blank on the list. This particular column is a child to a cascading list. Please help!

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Michael E. Gernaey 53,433 Super User 2025 Season 2 on at

Like (1)

Report

I need a macro for this

Please.... add.... pictures and code and eveything else sow e can help. Not just a couple sentences with no visualization contect etc.

Was this reply helpful? Yes No
TarunReddy 24 on at

Like (1)

Report

.

Was this reply helpful? Yes No
Suggested answer

TarunReddy 24 on at

Like (2)

Report

It sounds like the issue you're encountering is due to the form not patching the Lookup column correctly in your SharePoint list. To ensure that the Lookup column patches properly, you need to make sure the correct reference to the item is being used.

Open the form and select the DataCard of the unpatched column in my case it's the licenses column.

Note: It is better to change the source of the dropdown column to the direct source instead of choices function. That way you can see all the options we have from that list. In my case the dropdown used for the licenses column I changed the source to Filtered version of "Licenses" list.

If you look at the "Update" property, it's using the dropdown and patching the selected value.

Change the formula similar to this "

{Id: DataCardValue10.Selected.ID,Value:DataCardValue10.Selected.Name}

"

The above formula is the proper structure to patch SharePoint lookup column.

Now try to submit the form and check the lookup column value in the SharePoint.

Reply back with more info if you come across any problems.

Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
JC-25070522-0 8 on at

Like (1)

Report

@TarunReddy

My Update field shows correctly, but I think my Display name might be incorrect.

Is my understanding right where in the Display name, it is:

DataSourceInfo([@the list you are sourcing from],DataSourceInfo.DisplayName,the name of the column from the source list) ?

Was this reply helpful? Yes No
JC-25070522-0 8 on at

Like (1)

Report

@FLmike

Apologies, I was having a hard time explaining I forgot to post screenshots.

The Tool field is the Parent, while the Tool Sub-category is the cascade..

I wasn't sure what to put in the Display name field.

This is what is currently in the Display Name field (from the advanced section)

This is the screenshot from the SharePoint list with the sub-category missing.

This is what the form looks like, cascade works here.

FYI, it's my first time working with PowerApps.

Was this reply helpful? Yes No
TarunReddy 24 on at

Like (1)

Report

@JC-25070522-0

The Formula you mentioned for the Display Name is correct.

DataSourceInfo([@the list you are sourcing from],DataSourceInfo.DisplayName,the name of the column from the source list)

But this is just a Dynamic way of getting the name from the list, if you use "Column Name" this would work too as long as you input it as a text, and this doesn't count for the missing data.

The reason for the missing data for missing data is because of the update property.

{Id: ToolSubcategoryDropdown.Selected.ID,Value:ToolSubcategoryDropdown.Selected.Name}

property.

Try this. If this doesn't work, please share the formula for the Items property of the "Tool Sub-category" and update property of that columns data card.

Was this reply helpful? Yes No