Several General Questions

[Mrrcomp]

1) how can i tell if a screen has finished downloading the records? i.e. I have gallery on my screen and a label that i want to set visible true or false based on If(CountRows(Gallery1.AllItems)>0,false,true)

But It shows while the screen is loading the data..

2) is there an app quit command? that I can add to the actionbar?

3) I''ve created a POC app. How can i share the Power App with my client even though we are not both in the same "organization"?

Regards

MRRCOMP

[timl · Accepted solution]

Hi @Mrrcomp 

1. There isn't an easy way to tell if the screen has finished downloading the records. The gallery control is a special case because it includes built-in pagination. This means that when the user reaches the bottom of the gallery, the gallery control will load the next batch of records. Additionally, you could have several data controls on a screen.

2. You can call the exit function to quit an app.

https://docs.microsoft.com/en-gb/powerapps/maker/canvas-apps/functions/function-exit

3. You can share your app with external users by setting them up as guests. See the 'Share with guests' section here...

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/share-app

[Mrrcomp]

@timl 

Thanks.

1) About guest ..  I added a guest gmail account but when owner tries to login to powerapps mobile its says he needs a business email 📤 not personal.  

2)since powerapps is free with office365 can that account be a guest and have a gmail ?

[timl]

@Mrrcomp 

Power Apps works only with work email addresses, so unfortunately Gmail, Outlook.com, and other ISP/personal email addresses will not work (even when configured as a guest).

Does your client have a non Gmail account that they can use? If it's just a single client that you want to share your app with, perhaps you could create an account in your own organisation for that user?

[Mrrcomp]

@timl 

And if they purchase a per app license, 

[timl]

@Mrrcomp - It isn't so much the license - it's the fact that it can't be associated with a Gmail address. Therefore, a per app license would not help in this instance.

[Mrrcomp]

@timl 

HI Again thanks for your input

My situation is that this is a POC for a client. His email is not a Gmail account so I believe I wiill be able to add him as a guest. But the final project is for the following scenario.

My Client owns a Investigation company and he "outsources" various aspects of the investigation  to freelance investigators. He is running a "legacy" SQL based desktop application internally at the office. The PowerApp is to allow the Investigators to control and send their "reports"  to the SQL to save the office staff time in dealing with emails from the investigators.

So what I am trying to calculate is the costs/logistics to allow those Investigators (90% are using gmail) to use the powerapp 

Regards

MRRCOMP

[timl]

@Mrrcomp - Thanks for the clarification. That's very useful.

The difficult thing about this use case scenario is that those 90% of investigators that use Gmail will not be able to access the app.

Your client would need to create accounts for the freelance investigators in their tenant for this to work. Because the data source is SQL, the client would need to purchase premium licenses for each of those users, starting at $10/user/month.

If the client prefers not to add accounts for those investigators in their organisation, perhaps an alternative is for the client to obtain/setup a separate Microsoft 365 organisation specifically for this project. If you want to minimise costs, you could explore the idea of using a SharePoint data source in this environment. You could then build a data flow to send the SharePoint data to SQL Server, thus minimising the number of premium licenses that are required.

[Mrrcomp]

@timl

Hi

I started the process of purchasing a per app license and it seems that its allowing me to purchase using a regular gmail account. So perhaps there won't be an issue after all 🙂

Thanks for all your input ..

Regards

MRRCOMP

[timl · Accepted solution]

You're welcome @Mrrcomp  Let us know how you get on with your Gmail account.

Your project sounds very interesting. Good luck with that!