cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Selecting Item for Forms by Summary Dropdown

Hello,

 

I am triing to figure out, how to select item for one form by selecting choice.

I have custom dropdown populating all items from source (source is sharepoint list) and edit form when i would like to populate items based on selection of that dropdown.

 

I dont get probably the logic of Items but i dont know what may i do. 

 

E.g.: DropDown1 Data Source: 'Ticketing Tool'

Form1 DataSource: 'Ticketing Tool' Item: DropDown1.Selected (err Invalid Formula.Expected a value compatible with 'DataSource')

 

Any Help?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

I recreated this in my test environment to make it work so the names are different. 

 

Employees is the name of my SharePoint list connection

{Name} is a column in the list

 

DropDown1

Items = ShowColumns(Employees,"{Name}")

 

FormViewer1

DataSource = Employees

Items = LookUp(Employees,'{Name}'=Dropdown1.Selected.'{Name}')

 

I do have delegation issues with this method. Also, it assumes the Name column is unique.

 

Hopefully, this helps you move in the right direction. The big thing I did differently was I used the Lookup function to find the record you wanted in the data source.

Shane - Microsoft MVP, YouTube, and PowerApps Consulting for when you are in a bind to get this fixed quickly. And finally we now have PowerApps Training

View solution in original post

2 REPLIES 2
Super User
Super User

I recreated this in my test environment to make it work so the names are different. 

 

Employees is the name of my SharePoint list connection

{Name} is a column in the list

 

DropDown1

Items = ShowColumns(Employees,"{Name}")

 

FormViewer1

DataSource = Employees

Items = LookUp(Employees,'{Name}'=Dropdown1.Selected.'{Name}')

 

I do have delegation issues with this method. Also, it assumes the Name column is unique.

 

Hopefully, this helps you move in the right direction. The big thing I did differently was I used the Lookup function to find the record you wanted in the data source.

Shane - Microsoft MVP, YouTube, and PowerApps Consulting for when you are in a bind to get this fixed quickly. And finally we now have PowerApps Training

View solution in original post

Anonymous
Not applicable

Thank you for your reply @Shanescows,

That works perfectly and without delegation issues.

 

Now I have to customise the formula to show only choices when Author=User

 

Anyway, thanks a lot!

 

EDIT: ShowColumns(Filter('Ticketing Tool',Author.DisplayName=User().FullName),"Title") solved the purpose 🙂

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (7,582)