Set dropdown values based on login user in canvas app

(0) Share

Report

Posted on by Powerappsuser11

237

Hi community Team,

I created canvas app.Canvas app contain worklist and work dropdown and

datasource is sharepoint list,it's contains column email,work and worklist.
Based on login user work and worklist dynamically show login user records in canvas app dropdowns.

How can achieve thisone.Please Help

Thanks in Advance for earlier response....!

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

Shaheer Ahmad 2,194 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
To dynamically show the login user's records in canvas app dropdowns based on their work and worklist, you can follow these steps:
Start by adding the SharePoint list as a data source to your canvas app. Go to the "View" tab in the Power Apps Studio, click on "Data sources," and add your SharePoint list as a data source.
Create a connection to the Office 365 Users data source. This connection will allow you to retrieve information about the logged-in user.
Add a dropdown control to your canvas app and set its Items property to the following formula:

Filter('SharePointListName', email = User().Email)

Replace 'SharePointListName' with the actual name of your SharePoint list. This formula filters the list based on the logged-in user's email address, retrieving only the records that match.
Customize the display fields and values of the dropdown control as per your requirements. You can set the DisplayFields property to the column you want to display in the dropdown, and the Value property to the corresponding column that represents the unique identifier for each item.
Repeat the above steps for the worklist dropdown, adjusting the formula and column references to match the worklist column in your SharePoint list.
By following these steps, the dropdown controls in your canvas app will dynamically display the records from the SharePoint list that match the logged-in user's email, work, and worklist.
Remember to save and publish your app to apply the changes.
Powerappsuser11 237 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ShaheerAhmad

Thanks for early response. Can you provide logic on worklist and work dropdown.If you provide it will easy understand.
Thanks in advance for your help
Powerappsuser11 237 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ShaheerAhmad ,

Thank you so much, requirement achieved.