Answered

Sharepoint Data/Column Sharing

(1) Share

Report

Posted on by Powertron

I'm building an App with multiple forms, each with its own Sharepoint list to store the information. Forms are as follows :

Request

Setup

Go Live

Request is for users requesting a service, setup is admins setting this up and go live is as you'd imagine, a check list for when the service goes online.

I'd like certain information to flow through these forms, for example from the Request form to the Setup form I'd like to carry over details such as the requestor, details requested, time/date of request being filed etc. Is there a way to trigger a New Form page of my Setup list whilst indicating an entry on my Request list to get details from? So a New Form for "Setup" opens with some details pre-filed in from "Request"?

I'm looking to generate emails for users and admins for authentication reasons etc, so some sort of simple email trigger would be ideal.

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Powertron on at

Like
a
(1)

Report
Copy link

Link copied!

On thinking about it, is this something I could do with Power Automate? If there was a way to trigger a Power Automate job when I open a new form to fill in information from a previous form that I could somehow invoke through a link that would be IDEAL.
Verified answer

Silvester. Akakpo 783 on at

Like
a
(1)

Report
Copy link

Link copied!
Yes it is possible to preload data based on a selected item.
this is what you need to do
- On the select property of the record in the Request Gallery, you add this code
Set(VarRequestItem,ThisItem); Navigate(SetupScreen)
(Assuming "SetupScreen" is the name of the screen where the setup form is loaded), on each the various field you want to preload data, set the default field value to
VarRequestItem.Requestor
if you have a field named "Requestor" on both form. So on each field, change the attribute and add the appropriate VarRequestItem.attribute.

If this post is interesting, give a thumbs up, mark it as a solution for other people to find it as well.