cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
yougan
Helper V
Helper V

ALthough new is set to show department it is showing dash

I want to see as dash when editing the form and during other form modes such as new and view i should see department name

Although I applied logic correctly, new and view form showing as dash only. Please see refer attached screenshots

 

1 ACCEPTED SOLUTION

Accepted Solutions
eka24
Super User
Super User

Put one of the Departsments as the default in the formula:

If(SharePointForm1.Mode=FormMode.Edit,"-","Accounting")

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

View solution in original post

5 REPLIES 5
eka24
Super User
Super User

Can you show the logic or the formula you applied that is not working?

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Hi Eka,

 

Thank you for the response. I have attached in my first thread same in screenshot called C1. Below is the logic I used.

 

If(SharePointForm1.Mode=FormMode.Edit,"-",ThisItem.Department)

eka24
Super User
Super User

Put one of the Departsments as the default in the formula:

If(SharePointForm1.Mode=FormMode.Edit,"-","Accounting")

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Hi Eka,

 

This is working but why it is not working previous one. It supposed to work right? 

instead of column value and I would like to declare column title itself saying ThisITem.Department

eka24
Super User
Super User

The earlier formula did not work because the default of the dropdown picks a text at a time. When you use ThisItem, it is not clear which of the items in the list should be selected as the default.

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it. 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,822)