Friday, 30 July 2021

Join Multiple Tables in Canvas App using Lookup

 Hi all,

So, imagine that you have 2 tables

Table A: "Team Assignment" and Table B: "Player", with Player (Display Name: Player and Schema Name is new_playerid) is the Foreign Key



Now, I want to have gallery in CanvasApp that showing the Information:

Team Name, Player Name, and Date of Birth

I have been trying to find the answer and could not find it because typically if you just use lookup and without match the foreign key which is Player Id in this case, you will not get the correct Date of Birth, instead will just get the "first record" which is in the case is 1-Jul-95 (Donny's)

So, here is the answer:

Put the code in the Items property of the Gallery

AddColumns('Team Assignments', 

"PlayerObject", 

LookUp(Players, Player = 'Team Assignments'[@Player].Player))

With this, you can get all the columns from both tables, if you need just one column, you can just add it in the LookUp formula

Reference:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-table-shaping

Hope it helps!


New Geospatial Features in Power Apps

Hi all,

Microsoft recently launched the Geospatial Features in Power Apps early this year

https://powerapps.microsoft.com/en-us/blog/announcing-the-general-availability-of-geospatial-features-in-power-apps/

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/geospatial-overview#enable-the-geospatial-features-for-the-environment

Now, you can try it out!



Monday, 23 November 2020

Power Automate/ Microsoft Flow is not running for CDS (Current Environment) Connector triggers

 Hi all,


Have you encountered that your flow is not running or does not work?

It could be the reason:

Your CDS Organization is in Administration Mode with the Background Operation is disabled

To Solve:

Go to your Power Platform Administrator Centre

Then go to the Environment and Edit your environment


After that you can see if your organization is disabled or not

The issue here is not the Admin Mode but the Background Operation setting

Once you disable Admin Mode, it will auto enable the Background Operation Mode


After you enable the Background Operations or disable your Administration Mode, wait for few mins, your flow will start work again like Magic!

Remember, if your source or trigger is from another CDS, ensure also that the environment does not enable the Admin mode or ensure Background operations setting is enabled.

Hope this helps

Thanks







Saturday, 12 September 2020

Error in accessing PowerApps.com "A silent sign-in request was sent but no user is signed in. The cookies used to represent the user's session were not sent in the request to Azure AD. This can happen if third-party cookies are disabled"

Hi everyone,

Have you encountered this error? It may happen when you login to PowerApps.com

A silent sign-in request was sent but no user is signed in. The cookies used to represent the user's session were not sent in the request to Azure AD. This can happen if third-party cookies are disabled....

I just encountered this and actually the solution is indeed in the Error message itself

Can not create Powerapp - Power Platform Community


But.. What if I don't use Incognito?

Yesss.. that happened to me too.

First of all, according to my experience I think it is because I use multiple sign in information and credential accessing the PowerApps.com so it will pass multiple information to login.microsoftonline as well.

I accessed it with my demo account, my trial account, and of course my Microsoft account.

So, how did I solve it (when I am not using Incognito)?

I tried to delete the cookies

Initially I deleted the last 4 weeks but it does not work

So, I tried to view my cookies under Privacy and security

After that, I can see bunch of related login.microsoftonline, so I tried to remove all of it

(You may want to sign out from your Google first to keep the cookies in another device)

Then I managed to login now to my PowerApps.com

Hope it helps :)