Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

Using power apps - record a new entry into a table with an attachment and lookup fields

Posted on by 130

Hi BC Forum

How can I do the following in powerapps from a connected BC table

  • Allow user to add an attachment to the record from power apps, and capture image and store in new table record (per record - 1 image) 
    • table extension or custom table are both fine here
  • Use a lookup filter so fields on powerapps only show certain values

The goal is to create a powerapp that a user accesses through a web link, adds a record (parts request) and then triggers notifications to group members when a new record is added to the table

Side question - can a team members license perform this function in BC (vs. essentials/premium)

Thank you!.

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,428 on at
    RE: Using power apps - record a new entry into a table with an attachment and lookup fields

    Hi

    Have you reviewed this article? I mean it is hard to work with blob but if you have your own table and your custom API this maybe work

    I believe Team license could cause and issue since they have no "write" privilege  to some tables. But see the second article that can help

    powerusers.microsoft.com/.../398906

    joshanglesea.wordpress.com/.../

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: Using power apps - record a new entry into a table with an attachment and lookup fields

    Hello,

    We currently do not have dedicated Dev support via the Dynamics 365 Business Central forums, but I wanted to provide you some additional resources to assist. If you need assistance with debugging or coding I would recommend discussing this on one of our communities.

    www.yammer.com/dynamicsnavdev

    www.dynamicsuser.net/.../14

    I will open this up to the community in case they have something to add.

    Thanks.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,188 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,030 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans