You’re offline. This is a read only version of the page.
I've got a fairly simple form for me to fill out on SharePoint. Four form fields total, two are dependencies.
Name, TIN, Ad No., and My No.
These four columns are all lookup types. The first two reference a master list of names (Title column) and TINs (TIN column) on a SharePoint List "Address Log (Map)" - both type Text on source list. The second two fields also reference a separate SharePoint List "Pursuits Advertisements Log" (Ad No. column and My No. column), also text data types.
Unfortunately, the lookup fields won't transfer to my SharePoint List when I hit submit on the published form. Therefore, I tried updating the "Update" property for one of the fields as a test. But I can't figure it out.
Here is how I set up my formulas on PowerApps. They are all combo boxes.
Name (NameLU)_DataCard1
DataCardValue1
No dependencies
TIN_DataCard1
DataCardValue2
Depends on DataCardValue1
Ad No._DataCard1
DataCardValue3
No dependencies
My No.
DataCardValue7
Depends on DataCardValue3
This all works great within the PowerApp designer interface. However, like I mentioned, the lookup fields won't transfer to my SharePoint List when I hit submit on the published form.
Here is my "Update" property attempt:
For the Name form field's "Update" property, the formula below normally has "ID" where my first red "Value" is located (below). But that doesn't populate anything in Intellisense. For the second red "Value" (also below), I tried replacing it with "Title" from my original source data but that didn't do anything either. Intellisense wanted to put Value for both slots. After trying multiple different variations, I'm stuck. I'd be grateful for some help.
Update =
{
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
Id: DataCardValue1.Selected.Value,
Value: DataCardValue1.Selected.Value
}
@WarrenBelz
I believe it was the Ad No. However, now that I think more about it, since I had the data already existing in the list before using the new PowerApps SharePoint form, there may have been some human error where someone entered the wrong Ad. No. but the correct My No. Upon publishing the form, and attempting to correct the mistake, it resulted in the issue posted above. I'm not really sure though.
Thanks again,
@Kalki ,
Which one does not work ?
@WarrenBelz
Hey Warren! So sorry for the delay in response (and for anyone following the chain). I had to finish large projects for work.
What's listed below is what has currently worked for me with one exception. There have been times when I've attempted to alter an existing record where the changes do not stick. What's weird is that not all records have this issues only some of them. I can't find a consistent pattern to them. Also, I've set up SharePoint List alerts and the "changes" I submit on the form trigger the alert, but the email alert still shows the same data. This kind of makes sense because it displays what's actually in the List, but also doesn't because no change was actually made. Would you please review the following and let me know if anything stands out to you?
Thank you!
SharePointForm1
Name (NameLU)_DataCard1
Share
Report
All responses (
Answers (
Update = {
Value: DataCardValue1.Selected.Value,
Id:
LookUp(
'Address Log (Map)',
Title = DataCardValue1.Selected.Value
).ID
}DataField = "NameLU"Default = ThisItem.'Name (NameLU)'Display Name = DataSourceInfo([@'Pursuits Staffing'],DataSourceInfo.DisplayName,'Name (NameLU)')
DataCardValue1
No dependencies
Default = DefaultSelectedItems = {Value: ThisItem.'Name (NameLU)'}DisplayFields = ["Value"]Items = Distinct('Address Log (Map)',Title)SearchFields = ["Value"]
TIN_DataCard1
DataField = "LookupTIN"Default = ThisItem.TINDisplayName = DataSourceInfo([@'Pursuits Staffing'],DataSourceInfo.DisplayName,TIN)Update = {
Value: DataCardValue2.Selected.TIN,
Id:
LookUp(
'Address Log (Map)',
TIN = DataCardValue2.Selected.TIN
).ID
}DataCardValue2
Depends on DataCardValue1
DefaultSelectedItems = {TIN: ThisItem.TIN}DisplayFields = ["TIN"]Items = Filter('Address Log (Map)', Title = DataCardValue1.Selected.Value)SearchFields = ["TIN"]
Ad No._DataCard1
DataField = "AdNo_x002e__LU"Default = ThisItem.'Ad No.'DisplayName = DataSourceInfo([@'Pursuits Staffing'],DataSourceInfo.DisplayName,'Ad No.')Update = {
Value: DataCardValue3.Selected.Value,
Id:
LookUp(
'Pursuits Advertisements Log',
Title = DataCardValue3.Selected.Value
).ID
}DataCardValue3
No dependencies
Default = DefaultSelectedItems = {Value: ThisItem.'Ad No.'}DisplayFields = ["Value"]Items = Distinct('Pursuits Advertisements Log','Ad No.')SearchFields = ["Value"]
My No._DataCard1
Datafield = "MyNo_x002e__LU"Default = ThisItem.'My No.'DisplayName = DataSourceInfo([@'Pursuits Staffing'],DataSourceInfo.DisplayName,'My No.')Update = {
Value: DataCardValue7.Selected.'My No.',
Id:
LookUp(
'Pursuits Advertisements Log',
'My No.' = DataCardValue7.Selected.'My No.'
).ID
}DataCardValue7
Depends on DataCardValue3
Default = DefaultSelectedItems = {MyNo_x002e_: ThisItem.'My No.'}DisplayFields = ["MyNo_x002e_"]Items = Filter('Pursuits Advertisements Log', 'Ad No.' = DataCardValue3.Selected.Value)SearchFields = ["MyNo_x002e_"]
@Kalki ,
The elements of DefaultSelectedItems are
{DisplayFieldName: ThisItem.ListFieldName}Based on the information you have posted, what I have supplied is correct.
@WarrenBelz Gotcha. I guess I said "error" because after the data is posted to the record, it is still not viewable when I open it up. Surely there's another piece of information missing to populate the information. What else can I give you to troubleshoot?
Thank you for helping me with this.
@Kalki ,
That is not an error - I have given you what I believe is the solution based on the information you posted.
@Kalki ,
Based on what you have posted, the DefaultSelectedItems would be
DataCardValue1
{Value: ThisItem.Title}
DataCardValue2
{TIN: ThisItem.TIN}
DataCardValue3
{Value: ThisItem.'AdNo.'}
DataCardValue7
{'MyNo.': ThisItem.'MyNo.'}
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
MVP (Business Applications) Visit my blog Practical Power Apps
Address Log (Map
"Title" Single line of text
"TIN" Single line of text
Pursuits Advertisements
"AdNo_x002e_" Single line of text
"MyNo_x002e_" Single line of text
@Kalki ,
What type of columns are they ?
#1
WarrenBelz
791
Most Valuable Professional
#2
MS.Ragavendar
410
Super User 2025 Season 2
#3
mmbr1606
275
Super User 2025 Season 2
