Answered

Navigate to different screens based on record field value

Like (0) Share

Report

Posted on 14 Feb 2023 20:12:32 by ShawnPelletier

I'm customizing a SharePoint online OOTB form in a list to use power apps forms. I would like to navigate to different screens based on the status field value for that record. If I open the record in a list view and 'Status' field = Test, I want it to navigate to the Engineering screen. If 'Status' = Test2, I want it to navigate to the Assignments screen. I can't get this to work. I've tried two separate solutions from scouring the interwebs that have been unsuccessful.

TEST1:

(from Sharepointintegration.OnEdit or OnView)

Refresh('YourSPList');
EditForm(Default Form);
If(SharePointIntegration.Selected.Status.Value = "Test", Navigate(Engineering,ScreenTransition.Fade))

TEST2:

(from App.StartScreen)

If(DataCardValue63.Text = "Test", Engineering, Default)

Categories:

General Questions

All responses (9)

Answers (1)

ShawnPelletier 85 on 06 Apr 2023 at 13:22:37

Like (1)

Report

Re: Navigate to different screens based on record field value

Place the timer on the default form.
OnSave = SubmitForm('Default Form'); SubmitForm('Engineering Form'); [submit form for every form you have built]
OnEdit = SharePointIntegration
jdellipa 16 on 05 Apr 2023 at 21:29:58

Like (0)

Report

Re: Navigate to different screens based on record field value

Ah gotcha, what screen did you put this on? And also what is your OnEdit, OnSave, etc?

Thanks!!!
ShawnPelletier 85 on 05 Apr 2023 at 13:51:30

Like (0)

Report

Re: Navigate to different screens based on record field value

This is the formula I used in the timer end property:
If(DataCardValue63.Text = "Pending Engineering", Navigate(Engineering,ScreenTransition.Fade));
If(DataCardValue63.Text = "Pending Disqualification", Navigate(Assignments,ScreenTransition.Fade));
jdellipa 16 on 04 Apr 2023 at 18:49:59

Like (0)

Report

Re: Navigate to different screens based on record field value

Can you elaborate on "DataCardValue63.Text" and the Status in Sharepoint field name? Or provide the exact syntax? thanks man
ShawnPelletier 85 on 04 Apr 2023 at 13:33:39

Like (1)

Report

Re: Navigate to different screens based on record field value

I did get it working. I used "DataCardValue63.Text" which is the actual name of the control. 'Status' is the SharePoint field name.

Another step I learned the hard way:
To submit data from additional forms in your app you have to add them to OnSave of 'SharePointIntegration' like so:
SubmitForm('default'); SubmitForm('Form1'); SubmitForm('Form2'); etc
jdellipa 16 on 04 Apr 2023 at 03:19:16

Like (0)

Report

Re: Navigate to different screens based on record field value

Hey Sean,

I am trying to do something very similar did you ever get this fixed?
ShawnPelletier 85 on 15 Feb 2023 at 14:09:12

Like (0)

Report

Re: Navigate to different screens based on record field value

The Status.Value string gives me an error > Invalid use of (.). Status is a text input and I'll get the same error if I use .Text
v-bofeng-msft on 15 Feb 2023 at 02:58:40

Like (0)

Report
Re: Navigate to different screens based on record field value

Hi @ShawnPelletier ,

Maybe you could add a timer control and set it's

Duration

1000

AutoStart

true

Repeat

true

OnTimerEnd

If(SharePointIntegration.Selected.Status.Value = "Test", Navigate(Engineering,ScreenTransition.Fade))

Visible

false

Best Regards,

Bof
Verified answer

v-bofeng-msft on 15 Feb 2023 at 02:58:26

Like (0)

Report
Re: Navigate to different screens based on record field value

Hi @ShawnPelletier ,

Maybe you could add a timer control and set it's

Duration

1000

AutoStart

true

Repeat

true

OnTimerEnd

If(SharePointIntegration.Selected.Status.Value = "Test", Navigate(Engineering,ScreenTransition.Fade))

Visible

false

Best Regards,

Bof