Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Check Entries on Sharepoint List

(0) ShareShare
ReportReport
Posted on by 1,151

HI All

I have a sharepoint list where entries are made via a Powerapp.

I have a person lookup field which once populated will then populate hidden fields such as Department.

 

the problem i have is that people move departments and so therefore my Power BI reports are incorrect.

 

What i would like to do is create a flow that will carry out and Automated check (2 times a day) of the person and their department and if that has changed  update the list.

 

Is this possible?

 this is something new to me so i don't know if it can be done.

Thanks Gary 🙂

  • gazzo1967 Profile Picture
    gazzo1967 1,151 on at
    Re: Check Entries on Sharepoint List

    @DeepakS 

    So what would my first action/trigger be?

    Get Items?

    Thanks Gary

  • DeepakS Profile Picture
    DeepakS 2,301 on at
    Re: Check Entries on Sharepoint List

    Hi @gazzo1967 

     

    You can use Get user profile (V2) action to get user details. Please note this action will provide details if it exist in their O365 profile.

    you need pass user email address that you will get from SharePoint User field.

     

    Regards,

    -------------------------------------------------------------------------
    If I have answered your question, please mark your post as Solved.
    If you like my response, please give it a Thumbs Up.

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,691

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 65,019

Leaderboard