web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Change FormMode when n...

Power Apps

Unanswered

Change FormMode when no record is found in SharePoint for the signed in user

(0) Share

Report

Report

Posted on by KirwinM

2

I have a custom form that is currently in New mode.

I would like to update the existing item in the SharePoint list if a record was found for the signed in user.

Thus far in the DefaultMode property of the Form I have:

"If( CountRows('My Data Source'. 'Created By' = User().Email > 0, FormMode.Edit, FormMode.New)"

Please assist

Categories:

Building Power Apps

All responses Img

All responses (4)

Answers Img

Answers (0)

Sort by

SkiDK 1,016 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @KirwinM
You're practically there. Can you try it like this:
If(CountRows(Filter('My Data Source', 'Created By' = User().Email)) > 0, FormMode.Edit, FormMode.New)
KirwinM 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you. It seems to validate now.
However, the Screen now displays, "No item to display", whether I have a record in the SharePoint List or I removed my record.
Are there other properties to set?
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Following @SkiDK , if you want to edit something, you have to say which one you want to edit. So, you have to insert a gallery to choose the item and a button to create a new one
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
If( IsBlank( Lookup('My Data Source', 'Created By'.Email = User().Email ), FormMode.New,FormMode.Edit )

Join the conversation