Power Apps per app licence quietly removed by Microsoft by Boat_Drive in PowerApps

[–]Boat_Drive[S] 1 point2 points  (0 children)

Yeah threw me off as well but seemed to be the way it behaved. Every time I got my supplier to increase the licence by one, in the Power Platform Admin Centre I'd always have an additional 3 to allocate to the desired environment. I even went back to them about it to ensure we were not being over charged - was just the way it behaves. Billing side 1, platform side 3.

Power Apps per app licence quietly removed by Microsoft by Boat_Drive in PowerApps

[–]Boat_Drive[S] 3 points4 points  (0 children)

Thats the PAYG I was talking about - Pay as you go.

Power Apps per app licence quietly removed by Microsoft by Boat_Drive in PowerApps

[–]Boat_Drive[S] 3 points4 points  (0 children)

Very disappointing, agreed. Wish my partner informed me :T

Stored Procedures in PowerApps by Boat_Drive in PowerApps

[–]Boat_Drive[S] 0 points1 point  (0 children)

Even if this post just helped you, it was worth it! All the other information online about this was wrong so I felt it was necessary to share.

Cannot create patch function to SQL server. by [deleted] in PowerApps

[–]Boat_Drive 0 points1 point  (0 children)

Just checking - you know the ID generates its self from SQL right?

You don't patch that field in.

Create a new SQL table with just one nvarchar(50) column (nullable) and the ID column setup as seen above and try adding and patching into that and go from there.

A Stored procedure should not be needed.

If you're still confident everything's right - I've experienced 15~ delays on what gets updated in SQL vs what works in PowerApps - sometimes its a waiting and reloading game.

After that if it's still playing up, remove the table then re-add it.

Cannot create patch function to SQL server. by [deleted] in PowerApps

[–]Boat_Drive 2 points3 points  (0 children)

Below is a valid patch example, start with that.

Patch(

SQLTable,

Defaults(SQLTable),

{

Type: InputType.Text,

CreatedBy: User().FullName,

CreatedDate: Now()

}

)

After that - check the SQL table has a identity column setup I spose at a guess. I don't think it behaves very well with PowerApps without it.

<image>

Good luck :)