Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
Give Back to the Community this Month
Announcing Category Subscriptions!
News and Announcements icon
Power Platform Community / Forums / Power Apps - Community Calls Conversations / Need help Please
Power Apps - Community Calls Conversations
Suggested answer

Need help Please

(0) ShareShare
ReportReport
Posted on by JC-04111302-0 18
Hi Everybody
I am a beginner on PowerApps but with experience in PowerBi. I have managed to do a PowerBi integration with PowerApps by following lots of Tutorials ( doing my homework before coming to the community). I am writing back to an Excel Sheet  from which I am also reading. I can do so easily for 'Comments' field.
 
I am stuck right now, on what will seem simple for most of you
1: I have a CheckBox that I want on selection to insert a value of 1 ( True) in another Field ( Verified Flag). How can I do so?
2: How  can I populate the field ( 'Last Updated By' ) by the user who ticked the Checkbox?.
 
Needless to say that when I update the database ( Excel), with a value of 1 for a ticked Checkbox, when the user comes back to the record on PowerApps, the CheckBox should appear as Ticked.
Many thanks for helping me.
 
I
  • Suggested answer
    DBO_DV Profile Picture
    DBO_DV 4,244 on at
    Need help Please
    Hey, 
     
    The easiest way for you will be to add in DatacardValue6 Default the following:
    If(Checkbox1.Value, 1,0)
    Then you can make the Verify Flag_DataCard1 Visible Property to false. 
    To make it so that the value stays selected you need to add to the default property of the Checkbox :
     
    BrowseGallery1.Selected.'Verify Flag'=1
    For your Last updated by you need to add into the Default property of the Last updated TextInput this:
     
    User().FullName

Or

User().Email
    To be able to change a default property of a textInput in a form you need to unlock it first :
     
     
    You need to click on the Yellow part
     
     
    After this you can switch to display and select default. 
    then you can change it where you see Parent.Default.
     
    If this solvede your porblem please accept it as solution so others can find it as well. 
    If it helped in any other way consider liking it so we can keep supporting eachother. 
  • Suggested answer
    RyanAutomates Profile Picture
    RyanAutomates 70 on at
    Need help Please
    Hi,
     
    Just put into the value property of the Verify Flag control something like:
     
    If(Verify.value = 1, 1, Blank())
     
    Or you could put in the (I can't remember the name exactly) "OnTrue" property of the checkbox, you can set the value of Verify to 1.
    To make sure it stays ticked, you could hold the actual value for that field in a variable and then based on that variable, use it to set those values in the Canvas App fields. I suppose put the uncheck property to set it to 0? 
     
    And to find the current user's details, you can pull their M365 User info via:
     
    User().FullName //The full name of the user (e.g., "John Doe").
User().Email //The email address of the user (e.g., "john.doe@example.com").
User().Image //The profile picture of the user (URL to the image).
     
    Hope this helps! :)

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
Give Back to the Community this Month
Announcing Category Subscriptions!

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #9 Get Recognized…

Welcome to a brand new series, Tuesday Tips…

more Community News

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,867

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,161

Leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans