Retrieve username from a canvas app and store it in a MS List; when a user turns the toggle switch On/Off on canvas app

(0) Share

Report

Posted on by pujaclb

Hello,

I am new to power apps and am struggling with following problem.

I have a MS List named Demo1 with 5 columns namely:

Title(text)-name of machines,

EQ(number)-machine number,

Alarm(yes/no)-status of alarm,

DateTime(Datetime)- date and time

and Person(Person)- name of user

I have connected this list with a canvas app named Demo1 with UI just showing Title, EQ using labels and Alarm using toggle buttons, now I want that when a user selects the toggle button, the name of user and the date and time the toggle was clicked must get stored in the list. I used a patch function on Onselect property of toggle as

Patch(Demo1, First(Filter(Demo1, Title = Label1.Text)), {Alarm: Toggle1.Value}, {Person: User().FullName}, {DateTime: Now()}),

it throws an error that the expected type of argument of Person is record type but found type is text.
Any help would be much appreciated!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

BCBuizer 22,844 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @pujaclb ,

You can use the below to patch a person/group type column:

Patch( Demo1, LookUp(Demo1, Title = Label1.Text), { Alarm: Toggle1.Value, Person: {Claims:"i:0#.f|membership|" & User().Email,Department:"",DisplayName:"",Email:"",JobTitle:"",Picture:""}, DateTime: Now() } )

Ps. I also removed some unnecessary parts of the formula like extra curly braces.

Was this reply helpful? Yes No
pujaclb 15 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @BCBuizer thankyou for the help, it worked.

I have one more query, I have created a label to display the username and datetime when a toggle is turned on/ off on the app. And I am using following formula on Text property of label:

If(Toggle1.Value, Concatenate(Text(DateTimeValue(Now()), DateTimeFormat.ShortDateTime24), "/" , User().FullName), Concatenate(User().FullName, " /" , Text(DateTimeValue(Now()), DateTimeFormat.ShortDateTime24)))

Is there a way to retrieve last 2 records when toggle was clicked and display the details, last 2 records as in when the toggle was turned on followed by when it was turned off.

Was this reply helpful? Yes No
BCBuizer 22,844 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @pujaclb ,

Can you please open a new topic for this question? Like that it will be easier for other members of the community to find the solutions.

Was this reply helpful? Yes No