Power Platform Community Forum Thread Details

Hi all

Many thanks in advance for anyone who reads this, any help on this is much appreciate. This is my first Sharepoint List / Power Apps / Power BI item.

I have been tasked with producing a Risk Questionnaire App Form. I think that a Sharepoint List with a Power App UI is the right way to go, but if I am wrong please correct me.

There are multiple projects but the same questions and yes no answers only for each question.

There will be a bad answer for each question that will add 1 point to the risk score. The questions will default to the bad answer.

The questions can be grouped into common subject areas.

I would like the first screen to show the Risk traffic light for each section.

I had planned to put all the data into one sharepoint list, with columns for project name, project name (using sharepoint people?) and a column for each question.

I would then have a main menu screen, where the project name can be selected from a dropdown, this would then display the overall risk from each section. If the user was authorised (Project Manager or an admin) then the edit buttons would be visible and they could edit the risks in the section. Each risk question will have a toggle button to show yes no and change colour depending on good or bad.

I have seen mention of loading the data into a gallery or table but am not sure how as there are around 60 columns and how changing the selected by the dropdown would do that?

Is there any obvious errors in my thinking?

I haven't thought about the PowerBi connection yet, but is there anything I should consider?

Many thanks and kind regards

Categories:

Using Apps Using Formulas