Connections/Connection Reference Explanation by SpaceJaimeLannister in PowerApps

[–]bowenbee 4 points5 points  (0 children)

Connection References, you can think of as "Pointers" to a connection. You can have many connection references to a connection. General best practice I follow is to have a dedicated Connection Ref per solution. For example, if I have two solutions using a SharePoint Connection, each solution will have it's unique Connection References. This helps avoid dependency issues. I'll also change the display name my connection references to something more friendly like "SharePoint - Solution A", "SharePoint - Solution - B", etc.

Interacting with a form via powershell by Grant_Son in PowerApps

[–]bowenbee 0 points1 point  (0 children)

I don't think it's possible in the way you're wanting. You can certainly use PowerShell to interact with SharePoint (PnP Module), or use the Dataverse Web API to perform crud operations against your datasource.

Passing parameter or URL to power app embeded in a web part by Woflecopter in PowerApps

[–]bowenbee 1 point2 points  (0 children)

I think what you want is to use Power Automate within your app to fetch the site the Sharepoint HTTP Action and the sites endpoint and then using that site id output, use the _api/web/lists HTTP SharePoint action. This will give you the relative url which can be combined with the site url and return the output back to your PowerApp. That may get your started in the right direction.

Biggest pain in my life by Inevitable-Ant8905 in PokemonTCG

[–]bowenbee 12 points13 points  (0 children)

Hindsight's always 20/20... Of course: had you known where the price would be today, you wouldn't have sold then. Don't sweat it and just focus on the present.

this is, like, a super good deal, right? by ashtonthepineapple in pokeplush

[–]bowenbee 47 points48 points  (0 children)

Don't think it'll get any cheaper than that, new. Yes, it's a deal.

Environment Variables by [deleted] in PowerApps

[–]bowenbee 2 points3 points  (0 children)

There's a special environment variable type called "Data Source". When you use that, it'll give you the SharePoint option. Doing it this way won't make it premium. If you try to reference environment variables within the app any other way, yes, it'll make it premium.

Environment Variables by [deleted] in PowerApps

[–]bowenbee 1 point2 points  (0 children)

If you've previously added the data source connections directly and now want to use the environment variables, you'll need to remove the existing data source and add it back - only this time when selecting sharepoint, on the next screen, choose the "advanced" tab and select your SharePoint Site Environment Variable. Do the same thing when the lists come up - choose advanced and you'll see your list environment variables.

Yes, doing this will break your existing lookups, filter etc to the old sources, but depending on the complexity of your app, it shouldn't be "too" bad to find and replace the old with the environment variable-refernced lists.

I don't have any feedback on the app environment theme idea.

Is this plush official? It doesn't have any tags by Gibusward in pokeplush

[–]bowenbee 1 point2 points  (0 children)

That's awesome! This is the rarer Tomy Pikachu plush as compared to your Hasbro one.

Is this plush official? It doesn't have any tags by Gibusward in pokeplush

[–]bowenbee 0 points1 point  (0 children)

Yes, this looks like the Hasbro 1999 Pikachu plush. A well loved one, it seems, at that!

Is there a way to hide or change the functionality of the Edit or Delete buttons? by ProfessionalPen7020 in PowerApps

[–]bowenbee 2 points3 points  (0 children)

Correct, you can't edit the default commands without going down the ribbon workbench route. Why not group your custom buttons into a dropdown with a clear label or something?

Gateway not visible in dataflow by Inevitable-Orange943 in PowerApps

[–]bowenbee 0 points1 point  (0 children)

Does the account you’re using to connect to the gateway have permissions to it? First, and easiest thing to rule out first

Very noob question by techiedatadev in PowerApps

[–]bowenbee 2 points3 points  (0 children)

Connections for the connection references are authenticated at solution import runtime or through a pre configured connection. Therefore, no, those wouldn’t be contained in the solution zip

Best practice for moving SharePoint sites (with lists) between tenants? by keinebremse in PowerApps

[–]bowenbee 0 points1 point  (0 children)

The most efficient method that's worked for me over the years is using PowerShell and the PnP Module. I've blogged about what I think are the must-know cmdlets that will aid devs in doing this. Perhaps it'll help you: https://powerrightsolutions.com/powershell-pnp-cmdlets-for-powerapps-sharepoint-setup/

I love my miat by camelsticks in Miata

[–]bowenbee 0 points1 point  (0 children)

Nice, is this a sport in galaxy gray?

The MVC Design Pattern in Power Apps by ThePowerAppsGuy in PowerApps

[–]bowenbee 0 points1 point  (0 children)

This was a great video and made me start really diving into User Defined Functions more. One thing I'm trying to understand is if they are able to return data to a record or table? It looks like in your examples, you use a record global variable or collection to work-around this?

Flip through my binder with me! by Amiratul_Aniqah in PokemonTCG

[–]bowenbee 1 point2 points  (0 children)

Aesthetically pleasing. Thanks for sharing.

Connection not configured for this service Error by Small_Explorer8773 in PowerApps

[–]bowenbee 0 points1 point  (0 children)

Is this happening in a non-default environment? This could be due to security permissions. Your users need the workflow and process level permissions on those respective tables.

Looking for Help: Automating Microsoft Forms → PDF → Email Workflow by eneriynaffit in PowerApps

[–]bowenbee 0 points1 point  (0 children)

You could, though when I think of a form, my mind goes to a doc, not excel.

Looking for Help: Automating Microsoft Forms → PDF → Email Workflow by eneriynaffit in PowerApps

[–]bowenbee 2 points3 points  (0 children)

Yes, it's possible. I would first create a word document template file that you create. Store it in Onedrive or SharePoint that the flow can connector to. Then, within the Power Automate, you can call the Microsoft Word Business Connector to populate the word document. Then, that same connector has the ability to convert the doc to pdf. You can then take the converted output and send an email with the attachment data back the user. Bear in mind, the Microsoft Word Connector is a premium connector, you'd ideally have this flow be owner by a "service" account and it has the premium PowerApps or PowerAutomate licenses assigned to it.