web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Use value from datacar...
Power Apps
Answered

Use value from datacard in apps to power bi dataset or dataflow

(0) ShareShare
ReportReport
Posted on by Community Power Pla... Microsoft Employee

hi friends,

 

Is it possible to let the user input value to the datacard and let it look up a value from the power bi dataset or dataflow?

 

for example: user put the value "ABC" in Datacard and lets programs return value "Yes", if user put "DEF" its return "NO".

example of power bi dataset/dataflow

NameResult
ABCYES
DEFNO
Categories:
Building Power Apps
  • Verified answer
    v-yueyun-msft Profile Picture
    v-yueyun-msft Microsoft Employee on at

    Hi , @Anonymous 

    This is my test data in Power BI dataset:

    vyueyunmsft_0-1705901468056.png

    According to your description, you want to lookup the result in dataset. You can use this code:

    LookUp('PowerBIIntegration'.Data, Name=TextInput1.Text).Result
     LookUp('PowerBIIntegration'.Data, Name=ControlName.Text).Result
    The result is as follows:
    vyueyunmsft_1-1705901789536.png

    And you need to configure your Form -datasource /item property in your side.

     

     

    If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance! 

     

    Best Regards,

    Yueyun Zhang

     

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    @v-yueyun-msft thanks for your reply, but how can i add a specific dataset to powerapps ?

  • Verified answer
    v-yueyun-msft Profile Picture
    v-yueyun-msft Microsoft Employee on at

    Hi , @Anonymous 

    We can not add the special dataset to Power Apps, we can just put the field we need to this visual in Power BI.

    vyueyunmsft_0-1705907465398.png

    If you want to add another datasource , you need to add it in Power App:

    vyueyunmsft_1-1705907531146.png

    If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance! 

     

    Best Regards,

    Yueyun Zhang

     

     

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    @v-yueyun-msft how can i put power bi column to lookup formula, i tried but it always error.

     

    Supasit_1-1705910075984.png

    Supasit_2-1705910172041.png

     

  • v-yueyun-msft Profile Picture
    v-yueyun-msft Microsoft Employee on at

    Hi , @Anonymous 

    First , you need to check if your column Name is right in your side , you can use your mouse hover on the code:

    vyueyunmsft_0-1705910467843.png

    And you need to use the TextInput1.Text

     

     

    Best Regards,

    Yueyun Zhang

     

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    @v-yueyun-msft seem like its error but i now sure why

     

    Supasit_1-1705910843838.png

     

  • v-yueyun-msft Profile Picture
    v-yueyun-msft Microsoft Employee on at

    Hi , @Anonymous 

    Can you try to re-open this power app from Power BI report in Power BI Service?

     

    Best Regards,

    Yueyun Zhang

     

     

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    @v-yueyun-msft where could i reopen apps from power bi or i need to create new visual ?

     

  • v-yueyun-msft Profile Picture
    v-yueyun-msft Microsoft Employee on at

    Hi , @Anonymous 

    Can you try to click edit here to open the power App :

    vyueyunmsft_0-1705911828203.png

    And also you can re-create the Power App visual in Power BI and re-put the fields you need to pass to the Power app.

     

    Best Regards,

    Yueyun Zhang

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    @v-yueyun-msft Amazing! it works, thank you so much for your support.

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 345 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 225

#3
M Bilal Khan Profile Picture

M Bilal Khan 192

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans