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

Flow not populating created by correctly

I am using a SharePoint List with PowerApps. The PowerApp form was created with a generic O365 account. I use that same generic O365 account to create the flow in Power Automate. The trigger is a new item added to the list. The challenge is that the "Created By DisplayName" dynamic content or "Created By Email" is not grabbing the person that is filling out the PowerApp form but rather the generic O365 account. Am I missing a basic step here?

 

I'm not sure how to get around this but it is kind of a deal breaker if I can't determine who is submitting the form.

 

Any ideas?

 

1 ACCEPTED SOLUTION

Accepted Solutions
Pstork1
Most Valuable Professional
Most Valuable Professional

Yes, If you created the original connection using a generic account then that is the connection tied to your account. But when other people use the App they will be prompted to create their own connections and those will be under their account.



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

View solution in original post

12 REPLIES 12
efialttes
Community Champion
Community Champion

Hi
I see your point, when item is created via Flow, the user identified in Created by is the owner of the Flow, not the one executing it...

But please note according to this post:
https://powerusers.microsoft.com/t5/Building-Power-Apps-Formerly/Modified-By-field-in-sharepoint-lis...
If you edit the same item in PowerApps, the 'ModifiedBy' field will change to be the person who logged in (and I believe the same should happen when creatng items. As the post suggests... Can you share more about your use case? Are you using powe automate (aka flow) to create the new item in SP list instead of doing it directly in power app?
Hope this helps

Did I make your day? If so, mark my response as 'Solution' !!!

También escribo sobre Power Automate en este Blog y en Twitter

Pstork1
Most Valuable Professional
Most Valuable Professional

This is by design, but you can have the Flow change the Created By field using an HTTP REST call to whatever account you want it to be.  This post talks about how to do it with Modified By, but Created by will be the same,

http://johnliu.net/blog/2019/2/flowninja-hack-78-modifying-modified-by-and-modified-time-with-micros...



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

You're kidding me right?? This is way too complicated. All I'm trying to do is get the contact info of the person that CREATED the item in the SharePoint list. There isn't any modifying. Just create item in list and flow is triggered. Flow should "SEE" who created the item as the person that was logged in and filled out the PowerApps form.

 

Help!!!!!!!???!!!!!!!

 

 

Pstork1
Most Valuable Professional
Most Valuable Professional

Can you post a copy of your Flow?  If you are using the When an item is created trigger I have seen a problem with the timing involved not filling in the created By field right away.  You can also use the Modified By field.  When an item is created it sets both Created By and Modified by to the person who creates the item.  

 

I thought you were saying that you were creating the item using the Flow. Since the Flow is running in the context of the person who created the Flow that will normally result in a List Item where that person is the Created By. My answer is the only way to fix that issue. Are you just having trouble retrieving the Created By field from the trigger or could you be more specific about the problem.



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

The PowerApp form is for ONBOARDING. My flow is triggered by "When an item is created" in my SharePoint list. I then update the list to populate the account name and email address fields. Lastly, I email the contents of the list to a recipient.

 

How can I post a copy of the flow? You mean high level screen shot like below??

flow.PNG

Pstork1
Most Valuable Professional
Most Valuable Professional

The person who created the item should be available in the Trigger dynamic properties.  The Update Item will change the Modified By field to the Maker of the Flow, but won't change the Created By.  Sometimes the trigger doesn't record the Created By in time to include it in the trigger.  When an item is Created you can also use the Modified By field from the Trigger.  That seems to populate more quickly in the trigger.  When an item is created it will be the same user.  

 

Again, if the user is creating the item in a list and that is triggering the Flow then the Created By and Modified By in the trigger should be the user who created the item.  Can you be a bit more specific about your problem?  When Power Apps creates an item it will set Created By to the user running the Power App.  When Flow creates an Item it will set Created By to the user who created the Flow.  That is the way its designed to work.  Are you saying that is not what you are seeing?



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

Thank you for your explanation. Seems logical.

 

User goes to PowerApps form >> Fills out form >> Save >> List item created >> Flow gets triggered

 

When I put the "Created By DisplayName" [from "When an item is created" section in dynamic content] in the email the GENERIC SERVICE ACCOUNT display name shows up. Same happens for Modified DisplayName. So sad.

 

Is there a way to see what the Created By fields are by just looking at the list.

Pstork1
Most Valuable Professional
Most Valuable Professional

If the user is creating the list item directly from a Power Apps form, without the use of Power Automate, that is not the normal behavior.  Items created in Power Apps should be created using the identity of the user running the Power App, not the system account, even if the system account was the original creator of the Power App.  Is the Power App embedded in a page? That might account for the connections being done in the context of the system.  But that's not the way a normal Power App or a SharePoint Integrated Power App will work.

 

So the issue here isn't how to change the Created By.  The issue is something about the way the Power App is being used to create the new item.



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

Yah, I think that is just it. PowerApps is populating the Created By field by the SharePoint Integration account in PowerApps. This is a real bummer. I need to capture the person's account that is filling out the form.

Pstork1
Most Valuable Professional
Most Valuable Professional

But that's my point.  I just checked again on one of my SharePoint Integrated forms.  The item in the list shows Created by as the user who filled out and saved the form. If yours is showing as a system account then there is something off about your SharePoint Integrated form. Its not supposed to work that way.



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

Thank you for checking. I signed in as another user and submitted the PowerApps form and it DOES SHOW THAT USER as the created by. So it is working but for some reason, my account still is pointing to the generic. Maybe because I initially created the PowerApps form under my account and then changed the connection/integration to the generic account.

 

I think we are good to go.

 

Thank you again kind sir

Pstork1
Most Valuable Professional
Most Valuable Professional

Yes, If you created the original connection using a generic account then that is the connection tied to your account. But when other people use the App they will be prompted to create their own connections and those will be under their account.



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

Helpful resources

Announcements

Celebrating the May Super User of the Month: Laurens Martens

  @LaurensM  is an exceptional contributor to the Power Platform Community. Super Users like Laurens inspire others through their example, encouragement, and active participation. We are excited to celebrated Laurens as our Super User of the Month for May 2024.   Consistent Engagement:  He consistently engages with the community by answering forum questions, sharing insights, and providing solutions. Laurens dedication helps other users find answers and overcome challenges.   Community Expertise: As a Super User, Laurens plays a crucial role in maintaining a knowledge sharing environment. Always ensuring a positive experience for everyone.   Leadership: He shares valuable insights on community growth, engagement, and future trends. Their contributions help shape the Power Platform Community.   Congratulations, Laurens Martens, for your outstanding work! Keep inspiring others and making a difference in the community!   Keep up the fantastic work!        

Check out the Copilot Studio Cookbook today!

We are excited to announce our new Copilot Cookbook Gallery in the Copilot Studio Community. We can't wait for you to share your expertise and your experience!    Join us for an amazing opportunity where you'll be one of the first to contribute to the Copilot Cookbook—your ultimate guide to mastering Microsoft Copilot. Whether you're seeking inspiration or grappling with a challenge while crafting apps, you probably already know that Copilot Cookbook is your reliable assistant, offering a wealth of tips and tricks at your fingertips--and we want you to add your expertise. What can you "cook" up?   Click this link to get started: https://aka.ms/CS_Copilot_Cookbook_Gallery   Don't miss out on this exclusive opportunity to be one of the first in the Community to share your app creation journey with Copilot. We'll be announcing a Cookbook Challenge very soon and want to make sure you one of the first "cooks" in the kitchen.   Don't miss your moment--start submitting in the Copilot Cookbook Gallery today!     Thank you,  Engagement Team

Announcing Power Apps Copilot Cookbook Gallery

We are excited to share that the all-new Copilot Cookbook Gallery for Power Apps is now available in the Power Apps Community, full of tips and tricks on how to best use Microsoft Copilot as you develop and create in Power Apps. The new Copilot Cookbook is your go-to resource when you need inspiration--or when you're stuck--and aren't sure how to best partner with Copilot while creating apps.   Whether you're looking for the best prompts or just want to know about responsible AI use, visit Copilot Cookbook for regular updates you can rely on--while also serving up some of your greatest tips and tricks for the Community. Check Out the new Copilot Cookbook for Power Apps today: Copilot Cookbook - Power Platform Community.  We can't wait to see what you "cook" up!    

Welcome to the Power Automate Community

You are now a part of a fast-growing vibrant group of peers and industry experts who are here to network, share knowledge, and even have a little fun.   Now that you are a member, you can enjoy the following resources:   Welcome to the Community   News & Announcements: The is your place to get all the latest news around community events and announcements. This is where we share with the community what is going on and how to participate.  Be sure to subscribe to this board and not miss an announcement.   Get Help with Power Automate Forums: If you're looking for support with any part of Power Automate, our forums are the place to go. From General Power Automate forums to Using Connectors, Building Flows and Using Flows.  You will find thousands of technical professionals, and Super Users with years of experience who are ready and eager to answer your questions. You now have the ability to post, reply and give "kudos" on the Power Automate community forums. Make sure you conduct a quick search before creating a new post because your question may have already been asked and answered. Galleries: The galleries are full of content and can assist you with information on creating a flow in our Webinars and Video Gallery, and the ability to share the flows you have created in the Power Automate Cookbook.  Stay connected with the Community Connections & How-To Videos from the Microsoft Community Team. Check out the awesome content being shared there today.   Power Automate Community Blog: Over the years, more than 700 Power Automate Community Blog articles have been written and published by our thriving community. Our community members have learned some excellent tips and have keen insights on the future of process automation. In the Power Automate Community Blog, you can read the latest Power Automate-related posts from our community blog authors around the world. Let us know if you'd like to become an author and contribute your own writing — everything Power Automate-related is welcome.   Community Support: Check out and learn more about Using the Community for tips & tricks. Let us know in the Community Feedback  board if you have any questions or comments about your community experience. Again, we are so excited to welcome you to the Microsoft Power Automate community family. Whether you are brand new to the world of process automation or you are a seasoned Power Automate veteran - our goal is to shape the community to be your 'go to' for support, networking, education, inspiration and encouragement as we enjoy this adventure together.     Power Automate Community Team

Hear what's next for the Power Up Program

Hear from Principal Program Manager, Dimpi Gandhi, to discover the latest enhancements to the Microsoft #PowerUpProgram, including a new accelerated video-based curriculum crafted with the expertise of Microsoft MVPs, Rory Neary and Charlie Phipps-Bennett. If you’d like to hear what’s coming next, click the link below to sign up today! https://aka.ms/PowerUp  

Tuesday Tip | How to Report Spam in Our Community

It's time for another TUESDAY TIPS, your weekly connection with the most insightful tips and tricks that empower both newcomers and veterans in the Power Platform Community! Every Tuesday, we bring you a curated selection of the finest advice, distilled from the resources and tools in the Community. Whether you’re a seasoned member or just getting started, Tuesday Tips are the perfect compass guiding you across the dynamic landscape of the Power Platform Community.   As our community family expands each week, we revisit our essential tools, tips, and tricks to ensure you’re well-versed in the community’s pulse. Keep an eye on the News & Announcements for your weekly Tuesday Tips—you never know what you may learn!   Today's Tip: How to Report Spam in Our Community We strive to maintain a professional and helpful community, and part of that effort involves keeping our platform free of spam. If you encounter a post that you believe is spam, please follow these steps to report it: Locate the Post: Find the post in question within the community.Kebab Menu: Click on the "Kebab" menu | 3 Dots, on the top right of the post.Report Inappropriate Content: Select "Report Inappropriate Content" from the menu.Submit Report: Fill out any necessary details on the form and submit your report.   Our community team will review the report and take appropriate action to ensure our community remains a valuable resource for everyone.   Thank you for helping us keep the community clean and useful!

Users online (3,320)