Need help with status tracker code for SharePoint page

Question

**Edit to be clearer: The status tracker I am looking to build/implement will take data from a SharePoint List and display the status on a SharePoint page, it does not involve PowerApps at all other than to show where the current tracker points to (as a reference)**

Hi Community!

I need some help from the hive mind... I have a status tracker built into my SharePoint list that links to a PowerApps page currently, I need help converting it (either by code snippet or built-in mechanic if it exists) to work on a standard SharePoint page, I've included pics below to show the interaction...

SharePoint List Development tracker:

PowerApps endpoint:

In the list the different State/Country codes are a dropdown list that correspond to the different states shown in the PowerApps.

Please help a new SharePoint user (read: Noob, lol) out, thanks!

Answer 1

Dear Jerry,

May I know whether the information above helps you?

If it is convenient, please also send your feedback as follows as it may benefit the community process.

![Image](https://learn-attachment.microsoft.com/api/attachments/974db0b7-94b8-41e6-98a0-665778d3aa15?platform=QnA

Answer 2

Dear Jerry,

From your description, you customize the list form with PowerApps and the country code color will be changed based on the value selected from the dropdown status selection. You want to show the result screen in PowerApps on a SharePoint Online page.

If yes, you don't need the code. You just need to use the PowerApps web part to load the result screen.

Here is a demo for your reference.

.

For example, you create a form screen for submission as follows. Let the form screen redirects to the result screen Screen1 after submission. In my environment, I just list two country code in my list as a demo. I create two TextInput controls TextInput6 and TextInput7 to show AZ and GR value. You can hide them later.

Set TextInput6's Default as var1 and set TextInput7's Default as var2.

You can use the formula UpdateContext({var1:DataCardValue2.Selected.Value});UpdateContext({var2:DataCardValue3.Selected.Value});SubmitForm(SharePointForm1);NewForm(SharePointForm1);Navigate(Screen1,ScreenTransition.Cover) on OnSelect on the Submit button.

Use the formula NewForm(SharePointForm1) on OnSelect on the Reset button to add a new item next time.

On the result screen, the label AZ and GR will show the color based on the status selection.You can use the IF formula on Color on the labels.

AZ: If(TextInput6.Text="Deployed",Color.Green,If(TextInput6.Text="In Development",Color.Yellow,If(TextInput6.Text="Not Started",Color.Red,If(TextInput6.Text="Will Not Be Deployed",Color.DimGrey,Color.Black))))

GR: If(TextInput7.Text="Deployed",Color.Green,If(TextInput7.Text="In Development",Color.Yellow,If(TextInput7.Text="Not Started",Color.Red,If(TextInput7.Text="Will Not Be Deployed",Color.DimGrey,Color.Black))))

Add a Back to form button for users to go back to the form. Use the formula Navigate(FormScreen1,ScreenTransition.Fade) on OnSelect on the Go back to form button.

Add a Launch Site List button to load the site list to see the added items from the result screen. Use the formula Launch("https://contoso.sharepoint.com/sites/sitename/Lists/listname/AllItems.aspx") on OnSelect on the Launch Site List button.

Finally you can just create a SharePoint Online page, add one section for loading the submission form screen of PowerApps with the PowerApps web part.

After one submission, the form screen will be redirected to the result page and the users can directly go to the site list to see the items via the Launch Site List button.

.

Use the Power Apps web part - Microsoft Support

Hope that the information above helps you and have a nice day!

Thank you for your effort and time.

Sincerely

Cliff | Microsoft Community Moderator

Answer 3

Its not though, I need to build/employ a status tracker for my new SharePoint page not PowerApps... The current status tracker points to PowerApps but I need it to be employed on SharePoint.

Answer 4

Hi Jerry,

Thanks for posting in the community.

We would love to help you on your query, however, the situation you mentioned is related to Power Apps, and we have a specific channel Power Apps Communitycoping with such questions, I recommend you post a new thread there for expert help.

Sorry for that our category may have limited resources on checking on the situation further. Appreciate your understanding and patience.

Sincerely,

George | Microsoft Community Moderator