How to identify which type of account the signed in user uses ?

[Kadd]

Hello all,

Hope you're doing great.

I created a flow converting a powerapps form into a PDF. Works great and this conversion passes by OneDrive for Business. 

The problem is 2 of my external users only have personal accounts so when they open my form, they get an error message saying they cannot connect to OneDrive for Business, then the form closes.

Is there a way to have Flow figuring out which type of account the current user is using so i can set actions for OneDrive and actions for OneDrive for Business into a condition ?

Hope someone can help...

Thanks a lot and regards !!

[abm]

Hi @Kadd 

You mentioned your external users opens form. How they access the form? Is this a URL send via email? Could you explain the overall process? 

PowerAutomate service is a server side process. So there is no way to determine from client side who is using the form? 

Thanks

[Kadd]

Hi @abm ,

Thanks for your reply.

I have several lists on a SharePoint site. On one of them i created a tabbed form so one form can populate all my lists.

On one of the screens I have a button that launches a Flow that converts the entries from all the lists into a PDF.

My external users have access to my SharePoint site and thus...access to my PowerApps form. The problem is this form , due to the workflow converting the form into a PDF, is connected to OneDrive for Business. Since those 2 users connect with a personal Microsoft account, they access the site, they manage to click to open the form but it seems the "system" figures out that they use personal account so they don't have a Onedrive for Business (they have a simple OneDrive).

So i understand PowerAutomate is a server side process but there should be an interaction with the user account cause if you stup an approval, people can see they approval onto an dedicated and personalized page.

Then to me, it should be possible to have PowerAutomate figuring out what type of user account interacts with it... no..? 😄

Thanks !! 

[abm]

Hi @Kadd 

Thanks for your detailed explanation. What's your trigger here? When an item is selected?

Thanks

[Kadd]

Hi @abm ,

Well.. the trigger is... in this case, they just open the form and they get the error message. so they are stuck on the first screen and see the message coming . it asks "Would you allow a connection to OneDrive for Business?" and whatever the answer they choose (yes/no) the form gets blank.

Now the trigger for the PDF conversion is a button that references the corresponding workflow using a PowerApps call.

does that answer your question ? 🙂

[abm]

Hi @Kadd 

Thanks for your reply. Looks like this is not possible to do. You are looking for pre-operation to determine whether the user has access or not?

Thanks

[Kadd]

Hi @abm ,

no ...no, not if the users have access ... because they have access to the site, to the form etc... so this i know. 

But i'm trying to have Flow figuring out :

"This is the current user. this current user is connected with :    * a personal account

                                                                                                     * a work or school account "

so that I can then set a condition and say "if the user has a personal account, he will use OneDrive otherwise he will use OneDrive for Business"

There should be a way to do this ... when you send an invitation to an external user that external user has the choice between using a personal or a work/school account. this info should be stored somewhere ...

Otherwise a way to do it is a condition based  on domain names .. if the current user's email address contains gmail.com, yahoo.com, bidulebidule.com.. that will be complicated cause you have to think about domain names or make a list on your site so you can add some others... but then the question is ...how to find the email address ? 🙂

[abm]

Hi @Kadd 

Ok I got it. Do you want  a screen share to discuss this. Please email me your screen share details.

Thanks

[Kadd]

Hi @abm ,

oooh we can do that ??

stupid question but ...how ???? 🙂

I have to go now but will be back in 1h..1h30... i'm not expecting you to stay there and wait but maybe if you have a little bit of time tomorrow we could do it  ?

Thanks

[abm]

Hi @Kadd 

Thanks for the discussion. If you looking to give external users to access the PowerApps then please follow the below link.

https://wonderlaura.com/2020/04/15/power-apps-for-external-users/

Believe this should resolve your issue.

Thanks

[Kadd]

Hi @abm ,

thanks a lot for the conversation.

I will give this a try and let you know.

Thanks for your time ! 🙂