You’re offline. This is a read only version of the page.
I am trying to figure out how to connect data through SharePoint using the EditForm. The initial screen displays the names on the list, and to edit a name, you need to click on the edit icon.
Preview the app; upon clicking, a popup screen appears, but it still shows 'no item to display.'
When not in preview, the app is still able to display content from the SharePoint list.
I need to ensure that each text-input field in SharePoint is labeled with a corresponding name, allowing users to edit these names. Saving the changes will then update the corresponding items across SharePoint, ensuring that the user's matched name is currently displayed for their 'Class of 20XX'.
That's what I using for formulas for lookup: LookUp('Class of 20XX (Officers)','L-Grade'.Value = LookUp('Class of 20XX (Officers)','Head Sponsor' = User().FullName,'L-Grade').Value,'Class of 20XX Groups' that will be show as "Class of 2024" in the screen.
Perfect! Thank you! It's working well. Now, regarding the submission form for updating SharePoint, which formulas are we supposed to use?
Hi , @dylandavis09
Thanks for your quick response! If you want to show the default value in your Control in the Form , you need to check the DataCard-Default Value and the Control-Default:
And in this Expression "ThisItem.fieldName" , the "ThisItem" is your Form Item property.
So you need to check if your item return the correct record in your side and contains this field value. And also you can also custom the default value in your need to update the Default property.
Best Regards,
Yueyun Zhang
Yes!! But I have problem with that there no showing on text input it still blank when connected with ‘Class of 20XX (Officers)’. I trying to finding it out how it is fix it to showing on text input with each column. I’ll get you back in touch. I’m so tried. Haha
HI , @dylandavis09
Oh! Glad to hear you made it! Yeah~！
You can mark the reply for this case which can help more people in this forum!
Best Regards,
Yueyun Zhang
I found it, and solved it. I have bit mistake with property, oops. But I was put it in item property using:
Coalesce( LookUp('Class of 20XX (Officers)', 'L-Grade'.Value = LookUp('Class of 20XX (Officers)', 'Head Sponsor' = User().FullName, 'L-Grade').Value, 'Class of 20XX Groups' ), LookUp('Class of 20XX (Officers)', 'L-Grade'.Value = LookUp('Class of 20XX (Officers)', 'Sponsor 1' = User().FullName, 'L-Grade').Value, 'Class of 20XX Groups' ), LookUp('Class of 20XX (Officers)', 'L-Grade'.Value = LookUp('Class of 20XX (Officers)', 'Sponsor 2' = User().FullName, 'L-Grade').Value, 'Class of 20XX Groups' ) )
It's worked with items is show displayed!!!!
Hi , @dylandavis09
What is this code you put ?
Do you put the Form-Item property? In your screenshot , you are clicking the DataCard in your Form.
Best Regards,
Yueyun Zhang
@v-yueyun-msft Ahh! Thank you. Am I correct?
After that I have test with preview the app, but it's still show. 🙂
Hi , @dylandavis09
Thanks for your quick response!
Sure , you need to use the LookUp() function to get the one of the item you need to edit.
And for your above description, you click the edit icon to pop this Form , i think you can just use the same code in your first screen's Form-Item.
Best Regards,
Yueyun Zhang
Hi @v-yueyun-msft, okay, thank you. I'm currently experimenting with formulas involving LookUp. The idea is to use LookUp('Class of 20XX (Officers)' for all items in a row based on L-Grade to match, and then display the names based on the condition LookUp('Class of 20XX (Officers)','L-Grade'.Value = LookUp('Class of 20XX (Officers)','Sponsor 2' = User().FullName, 'L-Grade').Value).
this data will forward to (see below)
Hi , @dylandavis09
The item property need to put which item in your Datasource you need to update.
You can use the Lookup() function to get the item.
Best Regards,
Yueyun Zhang
#1
WarrenBelz
791
Most Valuable Professional
#2
MS.Ragavendar
410
Super User 2025 Season 2
#3
mmbr1606
275
Super User 2025 Season 2
Share
Report
All responses (
Answers (