Unanswered

EditForm Data with SharePoint on PowerApps

(0) Share

Report

Posted on by dylandavis09

438

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.

Screenshot 2023-12-10 at 1.58.37 PM.png

Preview the app; upon clicking, a popup screen appears, but it still shows 'no item to display.'

Screenshot 2023-12-10 at 1.58.49 PM.png

When not in preview, the app is still able to display content from the SharePoint list.

Screenshot 2023-12-10 at 1.58.57 PM.png

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'.

Screenshot 2023-12-10 at 1.59.15 PM.png

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (12)

Answers (1)

v-yueyun-msft on at

Like (0)

Report

Hi , @dylandavis09
According to your error code , it means your Edit Form is in Edit Mode , but there is no item in this Form.
You need to check the code you put in your Form -item property:
If you want to show the same as your first screen , you need to put the same code in your Form-item property.

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
dylandavis09 438 on at

Like (0)

Report

@v-yueyun-msft Oh, I understand now. What should I put in the items, and what formula should I use? It will display the item data, and when I click 'edit,' it will open the edit form, allowing me to edit all the names in each input. I'm trying to understand how it works with formulas.

Was this reply helpful? Yes No
v-yueyun-msft on at

Like (0)

Report

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

Was this reply helpful? Yes No
dylandavis09 438 on at

Like (0)

Report

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)

Was this reply helpful? Yes No
v-yueyun-msft on at

Like (0)

Report

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

Was this reply helpful? Yes No
dylandavis09 438 on at

Like (0)

Report

@v-yueyun-msft Ahh! Thank you. Am I correct?

After that I have test with preview the app, but it's still show. 🙂

Was this reply helpful? Yes No
v-yueyun-msft on at

Like (0)

Report

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

Was this reply helpful? Yes No
dylandavis09 438 on at

Like (0)

Report

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!!!!

Was this reply helpful? Yes No
v-yueyun-msft on at

Like (0)

Report

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

Was this reply helpful? Yes No
dylandavis09 438 on at

Like (0)

Report

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

Was this reply helpful? Yes No