Need help Please

(0) Share

Report

Posted on by JC-04111302-0

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.

Categories:

General Questions

All responses (2)

Answers (0)

Suggested answer

DBO_DV 4,663 Super User 2025 Season 1 on at

Like (0)

Report
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 139 on at

Like (0)

Report
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! :)