cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CameronTCD
Level: Powered On

Compiling SharePoint Lists

I have a SharePoint list which acts as a user list for individuals on my project across two softwares. 

I've mimiced this in an excel spreadsheet as seen below.

 

d3ZZ6Rk.png

 

We receive account applications through MS Forms.

 

If I recieve a ProjectWise account for Donald Moor, as an example, I want it to add the form information to his row (i.e add his email address to the pw acc? column).

If we recieve an account application for someone who doesn't have either account yet however, I want a new line to be created for this previously unrecorded user.

 

I had this working and accidentaly deleted the Flow!

Help to restore this would be much appreciated.

 

Any questions, ask away.

8 REPLIES 8
Super User
Super User

Re: Compiling SharePoint Lists

Hi @CameronTCD 

 

If you deleted your flow you can't restore it.

 

If you want to vote for this please see the below link.

 

https://powerusers.microsoft.com/t5/Flow-Ideas/Recycle-bin-for-deleted-flows/idi-p/111788

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!



CameronTCD
Level: Powered On

Re: Compiling SharePoint Lists

Hi @abm 

 

Apologies, I should've clarified...

I'm aware of this.

 

What I meant to say is how do I re-create this?

Super User
Super User

Re: Compiling SharePoint Lists

Hi @CameronTCD 

 

You'll need to use 3 excel actions and a parallel brach:

image.png

 

The trick is that you need to configure run after in  'Add a row into a table' action, by clicking in '...' and changing like below

image.png

And finally to grant that your flow end with success you need to use a 'Terminate' action after add row.

 

Your end result should be:

image.png

 

I have a video doind this, but is in pt-br: https://www.facebook.com/bernardes.rafael/videos/433868234003174/ look to 30:00.

 

Sorry for the audio, i changed the config and this cut my audio.

 

Best Regards,


Did I answer your question? Mark my post as a solution!

Gustavo Moraes, o astronauta brasileiro do Flow!


Super User
Super User

Re: Compiling SharePoint Lists

Hi @CameronTCD 

 

You need to use the trigger as 'Microsoft forms - When a new response is submitted'. Next you need to use the 'SharePoint - Get items' for finding this user exists in SharePoint list item or not. If not then create a new SharePoint -  list item. If it is an existing one then you need to check with form reponse to identify Projectwise or Projectmapper account then update the details using SharePoint update list item.

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

 

Thanks

 

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!



Super User
Super User

Re: Compiling SharePoint Lists

Hi @CameronTCD 

 

My suggestion is based on if you are storing the forms response in SharePoint list. If not then look at the suggestion from @gamoraes .

 

I got a little bit mixed up here whether you are using SharePoint list or Excel.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!



CameronTCD
Level: Powered On

Re: Compiling SharePoint Lists


 Next you need to use the 'SharePoint - Get items' for finding this user exists in SharePoint list item or not.


How is this done? I've tried conditions, filters and nothing really seems to work..

 

Regards,

Cameron

Super User
Super User

Re: Compiling SharePoint Lists

Hi @CameronTCD 

 

Did you tried the solution that I posted?

 

I think is the more easy way to achieve your issue


Did I answer your question? Mark my post as a solution!

Gustavo Moraes, o astronauta brasileiro do Flow!


CameronTCD
Level: Powered On

Re: Compiling SharePoint Lists

Yes, unfortunately this has not worked.

I am using SharePoint lists.

 

Apologies,

 

Helpful resources

Announcements
firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (3,934)