Forum Discussion
Solved
SPO List Calculated Column Link Not Displayed in Edit Form
I have a SPO list. Within the list is a Name and a Link to Materials column. The Link to Materials column is a calculated column that links the user to a filtered document library view based on the N...
MeganP2095 sounds good. FYI, no advanced formatting can be applied to modify the Edit/New/View forms directly. PowerApps and SPFx Form Customizer are the only way to modify those. I know this since I've had to do this for clients. SPFx is for developers, and PowerApps is for power users/developers.
** Note: You don't have to use a calculated field. I was showing one possibility using a calculated field. You can use the HtmlText and manipulate insert whatever you need in there as a filter for your view.
MeganP2095 I think you may need to use PowerApps to customize your edit form and use the HTMLText control and use the value of your calculated column to get it to display the hyperlink in the Edit form.
MeganP2095 I did a quick PoC with PowerApps and here is what my Edit form looks like afterwards:
** NOTE: You can hide the markup if you wanted to. For the purposes of my PoC I just wanted to show it.
In my case, I just created and added an HtmlText control and set the value using the calculated column markup. It's just pointing to the same list view with that filters the list items using the Sum value. DataCardValue6 is the calculated column value which is what generates the HTML markup.
Please like and mark as best response if this helps you 🙂
Seems easy enough to follow. I was hoping to avoid PowerApps as I haven't worked with it yet but what better time to jump in than now! I appreciate your input and I will give this a try and be back with an update.
MeganP2095 sounds good. FYI, no advanced formatting can be applied to modify the Edit/New/View forms directly. PowerApps and SPFx Form Customizer are the only way to modify those. I know this since I've had to do this for clients. SPFx is for developers, and PowerApps is for power users/developers.
** Note: You don't have to use a calculated field. I was showing one possibility using a calculated field. You can use the HtmlText and manipulate insert whatever you need in there as a filter for your view.
