Power Apps |WORK| Download Blob File

0 views

Skip to first unread message

Libby Ellwein

unread,

Jan 24, 2024, 11:18:57 AM1/24/24

to lastscapbasee

When you design a canvas app that connects to Azure Blob Storage, the app uses the blob storage account name and key to connect. After you share the app with others, users can use the connection configured inside the app to upload files to Azure Blob Storage without the need to share blob storage name and keys with the app users.

power apps download blob file

DOWNLOAD https://t.co/IcIYEdob5R

In this article, you'll learn how to create a sample canvas app that connects to Azure Blob Storage, and add controls to the app that allow you to upload different types of files to the connected blob storage.

Let me show you how to quickly build an app where you can display and upload images from/to your Blob store. We will use two Gallery, the first one to browse a container, and the second one that displays the files in the selected container. Finally, we will use some of the controls to show the user the files in your blob storage.

You can now try out your blob storage app by playing the app, uploading a file, put a full name (with the extension) in the text box and clicking on the button. Do not forget to change the popup window filter to All Files (button right) when it pops up (if you are trying this out from a browser).

You will want to secure your Azure Blob Storage files. Each container can have a different Public Access Level assigned to it. In Microsoft Azure Storage Explorer, you can click on a blob storage container, go to the actions tab on the bottom left of the screen and view your access settings.

After your app is made you will want to share that with your team. The wonderful thing with this connector is when you share the app, your team will get access to use the connector automatically and will not have to bring their own key to access the blob storage. With the previous version you would have to give each team member your access information to allow them to use it.

If you are currently using the Azure Blob Connector in your app it will continue to work. As you share your current app with other team members it will continue to work as it did before. If you need to update your app that will also continue to work. However, you will not be able to add new Excel data source from your blob storage.

I also considered using Azure Functions with vNet integration as a workaround (create a flow to upload the csv file to the blob storage).However, as these csv-files can be quite large, I dont want to transmit it's content via the HTTP-body. I would like to directly pass the csv as an input to the function. I am not sure if this is even possible.

A new month means it's time to celebrate and welcome the new user groups that have joined our community. We are excited to announce that we have more than 8 New Groups, which is no surprise after the amazing Microsoft Power Platform Conference. This month, we are breaking them out by the different community categories. If your group is listed here, give this post a kudo so we can celebrate with you!Don't forget to take a look at the many events happening near you or virtually! It's a great time of year to connect and engage with User Groups both locally and online. Please Welcome Our NEW User Groups Power Platform:PowerIT User Group: NottinghamPower Platform User Group: BergenPower Platform User Group: DanmarkNashville Power Platform User GroupMicrosoft Ambassador Program y Mujer Latina Technolochicas NCWIT CommunityCopilot Studio: Copilot User Group ItaliaDynamics365:Dynamics User Group AdriaticDynamic 365 Azerbaijan December User Group Events 01 Dec 2023Aprendiendo Desarrollo web, creando mi primer power app y power page.01 Dec 2023 Q4 Hybrid Philadelphia Dynamics 365 & Power Platform User Group Meeting05 Dec 2023APAC Dynamics 365 FastTrack Bootcamp - BI and Analytics07 Dec 2023Bay Area Power Platform Meetup: Learn, Share, and Connect07 Dec 2023Indiana D365/AX December User Group Meeting07 Dec 2023Dynamics User Group Meeting: Houston09 Dec 2023December '23 - NEW Power Apps User Group Meeting - Online12 Dec 2023December Cleveland Power Platform User Group Meeting12 Dec 2023RW2 Data Stewardship Open Forum Discussion13 Dec 2023 Black Country Power Platform User Group - December 2023 - West Midlands

In the bustling world of technology, two dynamic leaders, Geetha Sivasailam and Ben McMann, have been at the forefront, steering the ship of the Dallas Fort Worth Power Platform User Group since its inception in February 2019. As Practice Lead (Power Platform Fusion Dev) at Lantern, Geetha brings a wealth of consulting experience, while Ben, a key member of the Studio Leadership team at Lantern, specializes in crafting strategies that leverage Microsoft digital technologies to transform business models. Empowering Through Community LeadershipGeetha and Ben's journey as user group leaders began with a simple yet powerful goal: to create a space where individuals across the DFW area could connect, grow their skills, and add value to their businesses through the Power Platform. The platform, known for its versatility, allows users to achieve more with less code and foster creativity. The Power of Community ImpactReflecting on their experiences, Geetha and Ben emphasize the profound impact that community engagement has had on both their professional and personal lives. The Power Platform community, they note, is a wellspring of resources and opportunities, fostering continuous learning, skill enhancement, and networking with industry experts and peers. Favorite Moments and Words of WisdomThe duo's favorite aspect of leading the user group lies in witnessing the transformative projects and innovations community members create with the Power Platform. Their advice to aspiring user group leaders? "Encourage diverse perspectives, maintain an open space for idea-sharing, stay curious, and, most importantly, have fun building a vibrant community." Building Bridges, Breaking BarriersGeetha and Ben encourage others to step into the realm of user group leadership, citing the rewarding experience of creating and nurturing a community of like-minded individuals. They highlight the chance to influence, impact, and positively guide others, fostering connections that extend beyond mere technology discussions. Joining a User Group: A Gateway to GrowthThe leaders stress the importance of joining a user group, emphasizing exposure to diverse perspectives, solutions, and career growth opportunities within the Power Platform community. "Being part of such a group provides a supportive environment for seeking advice, sharing experiences, and navigating challenges." A Year of MilestonesLooking back at the past year, Geetha and Ben express pride in the group's growth and global participation. They recount the enriching experience of meeting members in person at the Microsoft Power Platform conference, showcasing the diverse range of perspectives and guest speakers that enriched the community's overall experience. Continuous Learning on the Leadership JourneyAs user group leaders, Geetha and Ben recognize the continuous learning curve, blending interpersonal skills, adaptability, and dedication to foster a vibrant community. They highlight the importance of patience, persistence, and flexibility in achieving group goals, noting the significance of listening to the needs and suggestions of group members.They invite all tech enthusiasts to join the Dallas Fort Worth Power Platform User Group, a thriving hub where the power of community propels individuals to new heights in the dynamic realm of technology.

The value of this setting would be the connection string to the Azure storage account. You'll find this in the Azure portal under "Security + networking" and "Access keys"
E.g: DefaultEndpointsProtocol=https;AccountName=portalwebapps;AccountKey=...;EndpointSuffix=core.windows.net

Below is a flow that starts from Power Apps and retrieves the apps in the environment and returns them with their data to the calling Power Apps. Since the return message contains not only JSON but also a description of its structure (schema), the result set can be utilized as such, for example, as a gallery value.

The new Azure Blob Storage Connector for PowerApps and Flow allows you to use Azure Blob Storage as a back-end component for your PowerApps and Flows. In this video I walk you through how to use the Azure Blob Storage Connector to combine the power of Azure and PowerApps:

My Power App Portal (Power Pages) environments are configured to use Azure blob storage for form attachments. One of the primary reasons for doing this is to avoid filling up expensive dataverse storage with endless attachments submitted by enduers.

This article outlines how to set up Azure storage: link

Don't forget to select a SharePoint site as well, which obviously needsto be the same site as in the List Folder step. The final step will writethe contents of the file to Azure Blob storage (configuration of blob storage isout of scope for this tip, but examples can be found in the tipsCustomized Setup for the Azure-SSIS Integration Runtime orCopying SQL Server Backup Files to Azure Blob Storage with AzCopy). Click onAdd an action. In the action screen, search for blob, chooseAzure Blob Storage and then select Create blob.

Now you can configure the action to create the blob. You can use dynamic contentto use the same file name. For the blob content, you need to choose FileContent from the dynamic content.

I would try to filter out the list from the objects returned by the "List Folder" action. Maybe "Filter Array" from data operations can help.

-us/azure/logic-apps/logic-apps-perform-data-operations

Regards,
Koen

We have a logic app setup which gets files from sharepoint and moves to azure blob. Trigger successfully moves files but flag shows error. For some reason in foreach Get File Content is trying to treat listname as file and trying to move the list and we getting error of status code =404. Please advice.