Power Platform Community Forum Thread Details

Showing/Hiding Sections Based on Previous Step of Multi-Step Form

I've run into an issue building my first site that I need some advice on. The site uses a multi step form where towards the end of the steps the form need to show or hide sections of the page that inform the user what evidence (files) they need to upload based on a series of questions completed earlier on in the steps. Quite a few of these sections will need to be shown/hidden based on multi choice fields & some of these are contained on a form step that uses a grid where there can be several records per applicant. There are two tables in the dataverse used by the website, one for the applicant details and another that stores details on other member of their household in a one to many relationship. I've been able to show & hide fields where they exist on the same form as well as sections with a bit of basic javascript that I've used for the first time. However, how can I access data on a multistep form where the data is from a previous step and potentially in a multi choice field (not all) where there can be multiple records per user in some cases? Would appreciate it if someone could recommend a best approach for dealing with this even if it is a sub optimal workaround!

Cheers

Categories:

General

First point to make is that you are not accessing data on the Form Steps themselves, unless you are currently on a Step and are accessing that Steps values via JavaScript - You are accessing Dataverse data.

To access dataverse data you have options such as using:

Portals Web API
Power Pages Flow
Liquid e.g. fetchxml (not so great for a multistep form)
Depending on what you need, another option is to include the info you need but hide it using CSS

For data on the main record that your final step is for I would probably include it on the form as readonly, with no label and then using Form/Step Metadata records hide each attribute with a CSS class (doing it in metadata will stop any screen flicker etc that you may get if you do it in JavaScript, metadata will not hide the label hence set it to not display the label on the dataverse form).

For items that may be in Subgrids, would consider querying using Portals Web API or a Power Pages Flow (both are initiated by JavaScript Ajax call, microsoft provide safeAjax wrapper code for the Web API), but would also see if there was a way I could update the main record on create/update of items in the subgrid e.g. a Realtime Dataverse Workflow or plugin that updates the parent record to the item in the subgrid (to make it easier and quicker to do stuff on the last step).

Portals Web API

https://learn.microsoft.com/en-us/power-pages/configure/web-api-overview

https://learn.microsoft.com/en-us/power-pages/configure/write-update-delete-operations#wrapper-ajax-function

https://learn.microsoft.com/en-us/power-pages/configure/read-operations

Power Pages Flow

https://learn.microsoft.com/en-us/power-pages/configure/cloud-flow-integration

Quick Links

Leaderboard