Finalize Power Apps Form Integration

€8-30 EUR

Completed

Posted about 1 year ago

€8-30 EUR

Paid on delivery

I'm nearing completion of a Power Apps form embedded in Power BI but need an expert to help with final integration fixes. The form should enable users to dynamically enter new records and update existing ones. Key Requirements: - Power BI filters (Region, Country, Period) should auto-fill in Power Apps without relying on static data from Microsoft Lists. - The form must always be visible with the fields to make users to input data, even when no data exists. - The Patch function must handle updates for existing records and create new entries without duplicates. The areas needing improvement include: - Auto-filling fields from Power BI filters (DIM columns like Country, Period/Qtr, Region are should be autofilled in the fields from Power BI, remaining 6 fact columns should be from the MS list to take data input from users) - Handling updates for existing records - Preventing duplicate entries Currently, the Power BI filters are being passed to the Power Apps form through PowerBIIntegration.Data. However, I'm encountering issues with not seeing the DIM data that should come from Power BI into Power Apps. Ideal Skills: - Deep knowledge of Power Apps and Power BI - Experience with dynamic data integration - Expertise in preventing duplicate entries - Proficient in using the Patch function for updates Please note, the project is almost complete, just need an expert to help with final tweaks and integration fixes.

PowerApps

Power BI

Project ID: 39224169

About the project

7 proposals

Remote project

Active 1 yr ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@TilagaA

€0 EUR in 1 day

5.0

(90 reviews)

7.0

7 freelancers are bidding on average €44 EUR for this job

@sheetal001

Data & Analytics Consultant | 10+ Years of Experience With 10 years of expertise in crafting data-driven solutions—from advanced visualizations to tailored analytics—I’m now venturing into freelance opportunities. • Leverage Power BI, DAX, Power Query, M Query, Power BI Apps, and Power Automate to build interactive and insightful data visualizations. • Utilize Dataflow and Semantic Models for efficient data integration and management. • Proficient in Looker Studio for creating interactive and data-driven dashboards. • Proficient in SQL (MSSQL, MySQL, T-SQL, Azure, Oracle, PostgreSQL, SAP Hana), SharePoint, Google Sheets, Salesforce, OpenAir, NetSuite, and SSIS for advanced ETL processes. • Skilled in C#, ASP.NET, Python, JavaScript, jQuery, HTML, and API development for end-to-end application development. • Expertise in Excel and Sisense, QlikView tool to support comprehensive data analysis and reporting. • I can share more sample dashboards on chat.

€30 EUR in 7 days

5.0

(15 reviews)

5.5

@futurrizon22

⭐⭐Hey! Hope you are doing well!! I understand you're nearing completion of a Power Apps form embedded within Power BI and require expert assistance to address final integration challenges. With extensive experience in Power Apps and Power BI, I am well-equipped to help you achieve a seamless and efficient solution. ✨Key Objectives: ☑️Dynamic Field Population: Ensure that Power BI filters (Region, Country, Period) auto-fill corresponding fields in Power Apps without relying on static data from Microsoft Lists. ☑️Persistent Form Visibility: Maintain a visible form with data input fields, even when no existing data is present. ☑️Efficient Data Handling: Utilize the Patch function to update existing records and create new entries, ensuring no duplicates occur. I recommend scheduling a meeting to review your current setup, identify any discrepancies, and implement the solutions outlined above.

€99 EUR in 2 days