Understanding the Deep Dive: Click-Through PowerApps Analytics Demo? (Patch + Connect)

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello PA community,

I'm attempting to implement the following features found in the analytics tutorial for PowerApps:

https://powerusers.microsoft.com/t5/PowerApps-Community-Blog/Deep-Dive-Click-Through-PowerApps-Analytics/ba-p/107820

However, our team has been hitting a few issues. For starters the data only patches when we use the template provided by the instructor. Creating our own SharePoint Lists/Tables or importing our own Excel spreadsheets do not work.

Secondly, our team is noticing that the Patch function works intermittently. For a few days, our team was able to track successfully in SharePoint and then it stopped tracking. So we began testing in OneDrive, which was working succesfully for a few days then it stopped.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (2)

Sort by

Shanescows 2,218 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Can you give a more concrete example of your code and what is failing? We are happy to help but need more info. 🙂

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so very much. We are attempting to track (2) data points:

1. Does user access the first screen
2. Does user access the second screen

On the initial screen we have OnVisible:
Collect(xxx_Analytics, {UserName:User().FullName},{UserEmail:User().Email},{LoginDate:Today()},{LoginTime:Text(Now())} )

On the second screen we have OnVisible:
Patch(xxx_Analytics,Last(xxx_Analytics),{DetailScreen1:"Y"})

Was this reply helpful? Yes No
Shanescows 2,218 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Okay. I just recreated your app and it works. So what is happening with you? Does 1 work and then 2 fails? Or Does 2 work and update the wrong record because 1 didn't work?

Excel is your data source? Is more than one user using your app at a time?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you.

Both 1 & 2 worked (intermittingly) in a SharePoint list and in a Excel spreadsheet via OneDrive.

The first few days we were able to track users actions by importing the Excel spreadsheet (provided by instructor) into SharePoint. However it stopped working after a few days, so we transitioned the spreadsheet/table to OneDrive; where it worked for a couple of days and then it has stopped.

We've only tracked a few users as of right now (we are still in testing).

When we launch the app in a few weeks, we will need to track 100-175 users per day.

Was this reply helpful? Yes No
Shanescows 2,218 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Take a look at this video by @ThatAPIGuy https://www.youtube.com/watch?v=OM-rlhKJFTA

It might help. I would be careful with you current solution to the problem. If you have 100 people in the app Last(record) isn't going to necessarily be the one the user created. So chaos will ensue. You are going to need a different approach. Maybe create a sessionID when the app starts and use that to track the record in Excel?

Was this reply helpful? Yes No
Verified answer

seadude 1,855 on at

Like
a
(1)

Report
Copy link

Link copied!

If you're going the "session ID" route with excel sheets, mr. dang has a solid video on this: https://www.youtube.com/watch?v=lIELJHaSWVE.

Good luck

Was this reply helpful? Yes No
Verified answer

ThatAPIGuy 925 on at

Like
a
(2)

Report
Copy link

Link copied!

@Shanescows

I have tried doing this with my colleague to clarify the confusion - We opened the app at the same time and clicked thorugh different screens and the datasource had collected the corresponding data for both. This means PowerApps recognizes each session with a sessionID internally and using the Last(record) recognizes the last record created in that specific session. So you don't need to create a separate session ID of your own necessarily.

Hope that makes sense. Someone else had the same question in our webinar as well.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you PA community (and pardon our delay in responding)!

We were able to reach out to the PA support team and identified the issue as having the wrong column type. We originally had the LoginDate/LoginTime columns as Single line of text; when it needed to be Date and Time.

Thank you again for all your feedback and support...we are able to track the necessary data points for our stakeholders.

Was this reply helpful? Yes No