Unanswered

Unable to click on "Format Text" for below Patch formula.

(0) Share

Report

Posted on by Punchy

Hi There,

I am a Power App new User which none of IT background. I followed the Leave Request Creation by using power app via youtube and I got stuck on this step. The Format Text is not allowed for a click. Could anyone please help me on this?

Thank you.

Patch('Leave Applied by Users',Defaults('Leave Applied by Users'),

{'Leave Type':Gallery7.Selected.'Leave Type'.Value},

{'From Date':StartDate.SelectedDate},

{'To Date':EndDate.SelectedDate},

{'Leave Title':TxtLeaveTitle.Text},

{'Leave Description':LeaveDetail.Text},

{'Requested By':

{ '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",

Claims: "i:0#.f|membership|" & Lower(User().Email),

Department: "",

DisplayName: User().FullName,

Email: User().Email,

'Job Title': ".",

Picture: "." }},

{'Requested To':

{ '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",

Claims: "i:0#.f|membership|" & Lower(_selectedApprover.Mail),

Department: "",

DisplayName: _selectedApprover.Displayname,

Email: _

selectedApprover.Mail }}

JobTitle: ".",

Picture: "." }},

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Punchy ,

Try the formula below:

Patch( 'Leave Applied by Users', Defaults('Leave Applied by Users'), { 'Leave Type':Gallery7.Selected.'Leave Type'.Value, 'From Date':StartDate.SelectedDate, 'To Date':EndDate.SelectedDate, 'Leave Title':TxtLeaveTitle.Text, 'Leave Description':LeaveDetail.Text, 'Requested By': { Claims: "i:0#.f|membership|" & Lower(User().Email), Department: "", DisplayName: User().FullName, Email: User().Email, JobTitle: "", Picture: "" }, 'Requested To': { Claims: "i:0#.f|membership|" & Lower(_selectedApprover.Mail), Department: "", DisplayName: _selectedApprover.Displayname, Email: _selectedApprover.Mail JobTitle: "", Picture: "" } } )

Best regards,

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

Like
a
(0)

Report
Copy link

Link copied!

Hi @Punchy ,

Due to a lack of context, can you please share a screenshot of the situation where you get stuck?

Was this reply helpful? Yes No
Punchy 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi BCBuizer, Thanks for helping me on this. Please find below screenshot.

Thanks,

Was this reply helpful? Yes No
Punchy 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Jeffer,

Do I Have to pass this without re-arranging on anything?

The Format Text still does not appear for my click. 😭

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Punchy ,

Can you see any errors now? Move mouse over the red waves, error message will tell you what's the issue.

Best regards,

Was this reply helpful? Yes No
Punchy 6 on at

Like
a
(0)

Report
Copy link

Link copied!

HI Jefferni,

Still does not work.

Was this reply helpful? Yes No