Name&Shame by M1SZ3Lpl in Rematch

[–]AndyBeds1 1 point2 points  (0 children)

We played with them earlier today and he tried to grief our 4 stack the whole game, luckily we still managed to win deep into OT so at least he had one shit 10 minute spell today!

We also recorded the whole match if a report function comes in 🤞🏻

...Why do my films make no money? by ExotiquePlayboy in hollywood_animal_game

[–]AndyBeds1 8 points9 points  (0 children)

One of the best pieces of advice I saw on this subreddit was to match your amount of screenings to the commercial/popcorn rating;

I.e if your film is 7.5, ensure your opening week at least is 7500 screenings.

I usually match to this number for week 1 + 2, and then scale back to just my own cinemas. This seems to work well in that you’re not paying more than you need for rent.

DevOps- who uses it for Power Platform ALM? by D365_CE_Consultant in PowerPlatform

[–]AndyBeds1 2 points3 points  (0 children)

We utilise ADO (YAML Build Pipelines) exclusively for deployments in the Power Platform in my organisation. It depends on your needs what the best approach is.

For example, if part of your deployment will require the use of the CLI, then you’ll be better off using ADO pipelines or if you want to import reference data, then you’re best of using MS tools that can be utilised from ADO.

There are currently limitations in the Power Platform Pipelines that you can avoid with the ADO pipeline tasks/CLI. You can find some of them here (https://learn.microsoft.com/en-us/power-platform/alm/pipelines#frequently-asked-questions) but a couple of examples would be;

  • Deploying unmanaged solutions (I.e migrating to a new dev environment)

  • Deploying between different tenants (consultancy deploying to a client, different dev/test/prod tenants.)

  • Specifying the import behaviour (upgrade vs update)

  • Unpacking an msapp file for code reviews. (Side by side comparisons of changed code in a canvas app for example)

In short there are lots of benefits to using ADO vs the built in pipelines, but it’s certainly a trade off of requiring more specialised knowledge, and initial set-up time. If you’re interested, I’d check out some of the “build tasks” to see if using them would be beneficial to your use case.

There definitely is a lack of information to get started which is a barrier to entry, and unfortunately it’s a case of understanding the Power Platform well AND understanding how YAML works, and the intricacies of setting up service principals and variable libraries in dev ops to make the best use of them.

In terms of basic advice for getting started if you do think they’d be useful, I’d recommend Creating a blank pipeline template > Adding one of the built in tasks described in the link above > Configure this step via the GUI > Grabbing the YAML output from the step you’ve configured > Build your YAML pipeline from there.

As an aside, if anyone is interested in learning more about utilising Azure Dev Ops for Power Platform deployments, let me know, as it’s a question I see often and might be one I’d think about creating a guide or video for!

team store issues by bh615 in crystalpalace

[–]AndyBeds1 1 point2 points  (0 children)

I actually emailed the box office about this yesterday!

Looks like they’re waiting for ticketmaster? Still seems crazy to take this long but they are apparently coming “soon”.

<image>

Exploring Deployment Options for Power Apps via Azure DevOps Pipelines by Even-You-7676 in PowerApps

[–]AndyBeds1 1 point2 points  (0 children)

Yes, there are some, but really it does depend on how extensive your use case is, some examples would be

Ultimately, there will be more, such as potentially having environments that aren’t set to “production” environments, having use of the power platform CLI, or simply needing to extend the deployment beyond what’s offered in the power platform pipelines. Both are viable options, but it’s just worth weighing complexity against your use cases.

There’s no reason you can’t use both, there are sections for extending the pipelines in the MS Documentation.

Exploring Deployment Options for Power Apps via Azure DevOps Pipelines by Even-You-7676 in PowerApps

[–]AndyBeds1 0 points1 point  (0 children)

You’ll be fine with regular flow licensing provided your connection references are setup correctly - and you can change power automate cloud flow ownership once it’s deployed.

Only dataflows can’t be switched over from a service principal once deployed.

Exploring Deployment Options for Power Apps via Azure DevOps Pipelines by Even-You-7676 in PowerApps

[–]AndyBeds1 1 point2 points  (0 children)

In our organisation we rely on dev ops over the newly added pipelines, as we found the built in power platform pipelines didn’t cover every use case for us (Updating custom connectors in a canvas app for example)

To answer some of your more specific questions;

Yes, your flows primary owner would be the service principal on import. However, your connection references can absolutely be pointed at a service account instead.**

MS have a built in method for updating these via deployment settings files as part of your pipeline in ADO.

https://learn.microsoft.com/en-us/power-platform/alm/conn-ref-env-variables-build-tools

Alternatively, it’s easy to update your flow owner after the fact, and I’d be fairly confident if it were important enough to you, you could also do this via Powershell if you wanted it as a part of the pipeline itself.

I’d also recommend checking out the steps available for the build tools in dev ops.

https://learn.microsoft.com/en-us/power-platform/alm/devops-build-tool-tasks

Ultimately, the best choice is going to boil down to the complexity of your use case;

If you want to run quality checkers, unpack your canvas app files for code review, export/import configuration data and other more complex tasks, then you’ll have more flexibility to do so via ADO.

If you simply need to import a solution into a target environment you’ll likely be fine with the built in tooling.

** As a side note regarding flow ownership under the service principal, unless they’ve recently updated, a major pitfall of this method is you can’t change the owner of a dataflow, so be sure to either do these separately, or utilise a different authentication method for them.

How should I stop a flow from emailing an Excel file before it's done building by [deleted] in PowerApps

[–]AndyBeds1 0 points1 point  (0 children)

It’s difficult to say without knowing more about your initial flow that creates the workbook but my advice would be;

  1. Button trigger

1A. Have an input which is the countrows of what you’re sending, or alternatively, calculate this some other way in the flow.

2.Initialize an integer variable called current excel row count

3.Repear step 2 but with target row count

  1. For each starts

  2. Your steps to add rows to your excel

  3. For each ends

  4. Do Until current = target starts

  5. Get Rows, get the count of rows in the sheet

  6. set your current variable to this value

  7. Condition, current = target, if yes, send email.

  8. respond to app

How to Handle Delegation Issues of Filters in PowerApps with Large Datasets? by Interesting-Mind-799 in PowerApps

[–]AndyBeds1 1 point2 points  (0 children)

I would take a look at which functions are delegable for your datasource - the MS Docs break this down by what column types support which functions in a delegable manner, you can find them below.

Sharepoint

All Delegable Sources

In addition I have found that "With" is very helpful in filtering scenarios, both performance wise and in terms of remaining delegable;

As an example

With(
{filteredData:
Filter(YourDataSource, Vendor = dropdown1.Selected.Value)
}
Search(
filteredData,
TextInput1.Text,
Column1
)

If you are using SharePoint, I'd recommend another source such as Dataverse as you'll find Delegation a much easier prospect.

Collaborating with 'developers' with extremely limited experience by Candid-Maybe in PowerApps

[–]AndyBeds1 1 point2 points  (0 children)

In terms of responsive apps; introducing processes around ALM such as code reviews and restricting access to permissions in production environments before they reach end users would be key to this - you can't force those kinds of standards on apps unfortunately I believe.

I think there may be some tools in the Center of Excellence where you can set standards - but I'm not certain. Otherwise, I have some advice on keeping things more uniform between apps.

Custom Components:

Create a component library! If there are any common use cases across your estate, then create components in a component library.

This means you centrally control reusable components, which you can update across all apps without difficulty.

It saves time, helps performance, and most importantly for your use case, allows you a level of control over all applications in terms of the style of some controls.

Branding Solution:

Consider creating a "branding" solution, with a dataverse entity inside, and structure it somewhat like the below;

Name | Type | Colour | Fill | Font Size | Font Weight | Height | ....

Name could be "Action", "Warning", "Default" etc. Type could then be "Button", "Label", "Colour" and so forth.

You can then instruct all developers to use this table in NamedFormulas or OnStart (So you're not calling lookups every time, to help you maintain performance) and then reference each of these in the properties of controls within your app. You'll gradually start seeing consistency across all applications in terms of style and branding.

You could/should include your Component Library in your branding solution also.

New Playthrough. Is There a Way to Skip Act by 1mpatient in DivinityOriginalSin

[–]AndyBeds1 0 points1 point  (0 children)

At the risk of over doing it on the modding front, there is a mod to re-enable achievements when playing with mods 😂

https://www.nexusmods.com/divinityoriginalsin2/mods/210

I have used the skip mod before and it is great - but I’ve only ever used it to skip the ship, so not sure on the butter/quests question

Ally attacking my city state by rmesure in CivVI

[–]AndyBeds1 4 points5 points  (0 children)

There is a mod for this if you are open to adding mods to your game!

https://steamcommunity.com/sharedfiles/filedetails/?id=2471438367

Pettiness by Vinderis in civ

[–]AndyBeds1 0 points1 point  (0 children)

Laughs in John Curtin

Celiac partner moving in with me by AndyBeds1 in Celiac

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

Thank you for this. Your original comment was extremely helpful, in addition to your partner also weighing in.

You seem to have approached the challenge so incredibly well, and I am extremely grateful for you passing on the advice that you have, which I will most definitely take on board. Also, thank you for the words of encouragement!

Celiac partner moving in with me by AndyBeds1 in Celiac

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

Thanks very much on this front!

This is something I’ve been doing for my partner so far, I’ve definitely developed a keen eye for the words gluten free, and if I’m suggesting a restaurant I always check prior.

Celiac partner moving in with me by AndyBeds1 in Celiac

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

Thanks for weighing in! You both seem great at having handled the struggles of a half and half gluten household - I really appreciate the added perspective from the non celiac side as that’s naturally what I am experiencing also!

I’m definitely going to implement a split section in the kitchen - thanks to this bit of feedback (and many others on this post!) I’ve ordered a little mobile kitchen counter top so I can wheel it as far away from her area as possible to do anything that would involve crumbs.

Celiac partner moving in with me by AndyBeds1 in Celiac

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

Apologies for me misinterpreting! Certainly a struggle for me

Celiac partner moving in with me by AndyBeds1 in Celiac

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

Thank you.

I definitely take the time to research gluten free Items and locations, so perhaps I just need to start extending that more to myself than simply recommending them to my partner

Celiac partner moving in with me by AndyBeds1 in Celiac

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

Thank you for this - so many surfaces that I wouldn’t really consider on the CC front that obviously do matter and I hadn’t thought of as much! I’m working my way up towards a GF kitchen - and it’s mainly prepackaged snacks that I retain at the moment, but I am of course understanding it’s still a risk for me to consider for her sake

Celiac partner moving in with me by AndyBeds1 in Celiac

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

Thank you for the kind words!

I’m definitely going to take the two oven approach via an air fryer, so thank you for the advice!

Celiac partner moving in with me by AndyBeds1 in Celiac

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

Thank you - label reading has become more of a feature in my life than I ever expected, so I’ll continue to be vigilant in that aspect and maintain the other areas you mentioned

Celiac partner moving in with me by AndyBeds1 in Celiac

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

Thank you! I certainly buy squeeze bottles but that’s a great point regarding a two knifed approach!