cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PeterGMcDermott
Level: Powered On

Onboarding Template Setup Trouble

Hello, I've tried setting up the onboarding template, however I don't see any opportunity (or documentation) to assign an Excel file in which to save the data for the app. Therefore, once I install and publish it, it looks great! Even embeds into Microsoft Teams, which is what I'm trying to do--however, whenever I make changes (like Company Name) it always reverts back to the default.

 

Am I missing a step during installation? Is there better documentation somewhere?

 

Appreciate your help!

Peter McDermott
16 REPLIES 16
Community Support Team
Community Support Team

Re: Onboarding Template Setup Trouble

Hi @PeterGMcDermott ,

Could you please share a bit more about your scenario?

Do you means that you could not make some changes within the template app?

Further, do you make this template app as your own app on your side?

 

The user @skidmarks64 has faced same issue with you, please check my response within the following thread:

https://powerusers.microsoft.com/t5/Creating-Apps/Onboarding-Tasks-Template/m-p/239261/highlight/fal...

 

On your side, please check if you have saved this template app as your own app within your PowerApps. Please consider take a try to click "Make my own app" option to save this template app as your own app, then re-load your saved app. After that, you could make some changes to your own app.

Please also consider check the attached GIF screenshot for more details:

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
PeterGMcDermott
Level: Powered On

Re: Onboarding Template Setup Trouble

Thank you for your response @v-xida-msft ,

 

I've followed the steps included in your GIF very carefully. Each time I make a change (for example the Comapny Name) it defaults back to the original value (Fabrikam). So the app appears to be working, but none of the data is being saved.

Peter McDermott
Sveeramachaneni
Level: Powered On

Re: Onboarding Template Setup Trouble

@PeterGMcDermott I'm running into the same issue with the company name not saving or anything. Did you ever figure out a fix or the reason why it wasn't working for you? 

PeterGMcDermott
Level: Powered On

Re: Onboarding Template Setup Trouble

No, I gave up.

Peter McDermott
russrimm
Level: Powered On

Re: Onboarding Template Setup Trouble

I'm facing the same challenge, has anyone gotten this template to work?  

Sveeramachaneni
Level: Powered On

Re: Onboarding Template Setup Trouble

Yes I did! Turns out that the template uses a collection defined in the "App" screen of the app. It's very annoying that they didn't mention you need to change it up. I had to break the app down completely to figure it out. Took so many hours I'll never get back... Thank you for reminding me to post here!

@PeterGMcDermott @v-xida-msft Here is the soultion as well in case you either find someone else with the issue or want to use the template again.

Here are the steps to get it working with the Excel file that it creates for you when you set it up:

Spoiler

1. Go to View --> Data Sources, click + Add data source and then find the Excel file that is created and load it. Click NO when it asks you if you want to replace the data for every header (VERY IMPORTANT)

Data Sources.PNG

2. Go to the "App" screen in the app (its the screen right before the "Welcome Screen"

  • This is where the variables and collections for the entire app are defined.

App.PNG

3. Expand the OnStart formula bar. You'll notice that there is a lot of "ClearCollect" for all the variables that are used in the app that are defined by string values. This is the reason why nothing you change in the app does anything!

OnStart.PNG

Here is the code I changed it to. You might need to change it to fit your needs as I already made changes to the app as I need it:

Spoiler
Concurrent(
    ClearCollect(Administrators, Administrators_1),
    ClearCollect(Tasks, Tasks_1),
    ClearCollect(TasksTwo, Tasks14),
    ClearCollect(TasksThree, Tasks1415),
    ClearCollect(TasksFour, Tasks141516),
    ClearCollect(TasksFive, Tasks14151617),
    ClearCollect(Resources, Resources_1),
    ClearCollect(Team, Team_1),
    ClearCollect(TeamLinks, TeamLinks_1);
    ClearCollect(Company, Company_1); 
    ClearCollect(CompanyLinks, CompanyLinks_1); 
    ClearCollect(LeadershipLinks, LeadershipLinks_1),
    ClearCollect(Leadership, Leadership_1),
    ClearCollect(FAQs, FAQs_1),
    ClearCollect(Contacts, Contacts_1),
    ClearCollect(ProfileStatus, ProfileStatus_1)
);

 

And viola! Any changes you make in the Excel sheet you linked in the earlier data source addition, will be reflected in the app now!

You will also need to add these data sources as they are not added automatically:

Office365Users
Office365
OutlookTasks

Data Sources to add.png

 

Once you do all the above, save the app, quit and relaunch it. Any formula errors should resolve themselves.

Let me know if you run into any trouble and I'll do my best to assist.

 

Edit: Fixed spelling mistakes

Elia
Level: Powered On

Re: Onboarding Template Setup Trouble

Hi!
@Sveeramachaneni ;  What a luck that you responded to this issue just yesterday, as I started with powerapps for the very first time today, and I was facing this issue too...

I am really new on this, therefore, I think I am getting lost with your explanation...

I can see, you have substitute the "strings" by something else. But then, where do you create those to assign them to their right sections, and fill them with the text information?
(sorry if this sounds basic, I just started 😞 )

So, for example, currently we have the following:

ClearCollect(Team, {Name: "Marketing Team"})

You replace the code by:

ClearCollect(Team, Team_1)

Where have you created a variable called: Team_1, to assign it with your specific information?
And furthermore, when the String contains multiple data, like for example:

ClearCollect(FAQs, 
{Question: "Lorem ipsum dolor sit amet consectetur adipiscing elit, sed do?", Answer: "Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum"} )

How do you insert all that info (Question; Anwer) in the variable?

Thank you very much!!!

Elia
Level: Powered On

Re: Onboarding Template Setup Trouble

I think, my main issue is that the app does NOT save any excel file. I did connect it to OneDrive for Bussiness at the beggining, when the option pop up in the top. But when I try to find the excel file, it is nowhere.... Has anybody had this same issue?

ryanalbert99
Level: Powered On

Re: Onboarding Template Setup Trouble

Yes I had the same issue. Any changes I wanted the app to save I had to make the changes by selecting app and editing the code in the function section. I have yet to find the excel spreadsheet to the app. The only spreadsheet that shows up is when you create your own version of the app.

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Users Online
Currently online: 352 members 5,536 guests
Please welcome our newest community members: