sergeluca / Power-Platform-BPM-Toolkit

Power Platform BPM Toolkit
MIT License
68 stars 12 forks source link

Error while trying to create the lists on sharepoint #12

Open thomasgg8 opened 2 years ago

thomasgg8 commented 2 years ago

So I was trying to get the BPM to work but apparently when I'm trying to change the values in the spreadsheet but couldn't make it to work.

The flow never works and I don't really understand the error behind it.

this is what it says: "The server did not receive a response from an upstream server. Request tracking id '08585669775597882788482265723CU24'."

Do you know why this could be?

image image

Thank you in advance.

henrikStr commented 2 years ago

I have the same problem. Was there a fix for it?

sergeluca commented 2 years ago

Hi All, I will take a look at this problem tonight and I will be back to you

Serge Luca

Office Applications and Services (Office 365) MVP

Business Applications (Power Automate & PowerApps) MVP

Creator of the open-source Power Platform BPM Toolkit

https://github.com/sergeluca/Power-Platform-BPM-Toolkit

Power Platform Associates, Belgium

P: +32 472 885 928

E: @.**@.>

Bloghttp://sergeluca.wordpress.com/ | Linkedin http://www.linkedin.com/in/sergeluca | Twitter http://www.twitter.com/sergeluca | Webhttp://www.shareql.com/

[cid:9b1d5fb8-94ce-4c13-98e0-19d2b8eedb16]

[cid:52eeef70-47e8-42e6-8af7-358fd56d29b4]


From: henrikStr @.> Sent: Tuesday, 18 January 2022 13:48 To: sergeluca/Power-Platform-BPM-Toolkit @.> Cc: Subscribed @.***> Subject: Re: [sergeluca/Power-Platform-BPM-Toolkit] Error while trying to create the lists on sharepoint (#12)

I have the same problem. Was there a fix for it?

— Reply to this email directly, view it on GitHubhttps://github.com/sergeluca/Power-Platform-BPM-Toolkit/issues/12#issuecomment-1015378383, or unsubscribehttps://github.com/notifications/unsubscribe-auth/ACXEHP6W454YID6X2DUT3VDUWVOSDANCNFSM5FYQGCOQ. Triage notifications on the go with GitHub Mobile for iOShttps://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Androidhttps://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub. You are receiving this because you are subscribed to this thread.Message ID: @.***>

sergeluca commented 2 years ago

Hi Henrik,

just to make sure I fully understand the steps you followed. In the Spreadsheet, you just added your system account and your SharePoint site URL ? Next you started the flow "BPM Toolkit - ALM - Create BPM Toolkit Structure". This flow is supposed to create your SharePoint lists and update the spreadsheet with the SharePoint lists URL.. Is the Flow "BPM Toolkit - ALM - Create Lists" activated ?

henrikStr commented 2 years ago

Hi Serge,

yes that is correct. I added my site url and the account to the excel file and started the Create BPM Toolkit Structure Workflow.

The first error occurs in the BPM Toolkit - ALM - Create Lists (which is activated) workflow at the Delete BPMList step, because the list is not found. Which is ok I guess, because it was not yet created.

Afterwards the list Part Time and its columns are created on the site.

The second error occurs while adding the Column “User Lang” to the view. The workflow does not run any further.

See this message:

{

"status": 400,

"message": "Column 'User Lang' does not exist. It may have been deleted by another user.\r\nclientRequestId: a2a73365-b925-415c-89e5-703d82f646a1\r\nserviceRequestId: 79f417a0-d010-3000-a194-3fbdafa8b51c",

"source": https://semtalk.sharepoint.com/sites/BPMToolkit/_api/web/lists/getByTitle('Part%20Time%20Request')/Views/GetByTitle('All%20Items')/ViewFields/addViewField('User%20Lang') …/sites/BPMToolkit/_api/web/lists/getByTitle('Part%20Time%20Request')/Views/GetByTitle('All%20Items')/ViewFields/addViewField('User%20Lang'),

"errors": [

"-2147024809",

"System.ArgumentException"

]

}

The column exists if I take a look in the list settings. I am able to add the column to the view by hand.

The Create BPM Toolkit Structure Workflow just throws a Bad request error message after a while and stops.

Could this be a problem because the addViewField API request looks for 'User%20Lang' and not for 'UserLang' ?

Have a nice day,

Henrik

Von: sergeluca @.> Gesendet: Sonntag, 23. Januar 2022 16:58 An: sergeluca/Power-Platform-BPM-Toolkit @.> Cc: henrikStr @.>; Comment @.> Betreff: Re: [sergeluca/Power-Platform-BPM-Toolkit] Error while trying to create the lists on sharepoint (#12)

Hi Henrik,

just to make sure I fully understand the steps you followed. In the Spreadsheet, you just added your system account and your SharePoint site URL ? Next you started the flow "BPM Toolkit - ALM - Create BPM Toolkit Structure". This flow is supposed to create your SharePoint lists and update the spreadsheet with the SharePoint lists URL.. Is the Flow "BPM Toolkit - ALM - Create Lists" activated ?

— Reply to this email directly, view it on GitHub https://github.com/sergeluca/Power-Platform-BPM-Toolkit/issues/12#issuecomment-1019513536 , or unsubscribe https://github.com/notifications/unsubscribe-auth/AULEIR5RGQM2YSIM26TFYBDUXQQQNANCNFSM5FYQGCOQ . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub . You are receiving this because you commented.Message ID: @.***>

henrikStr commented 2 years ago

Hi Serge,

I was able to get the BPM Toolkit to work. I had to change the name of the column and to active and fix/activate some of the flows by hand.

I have an additional question about the next release. In the readme file in github you announced the production mode release for this February. I have not found further information about it. Therefore my question: Is the production mode coming this month and will it be able to handle attachments and files?

With kind regards,

Henrik

Von: sergeluca @.> Gesendet: Sonntag, 23. Januar 2022 16:58 An: sergeluca/Power-Platform-BPM-Toolkit @.> Cc: henrikStr @.>; Comment @.> Betreff: Re: [sergeluca/Power-Platform-BPM-Toolkit] Error while trying to create the lists on sharepoint (#12)

Hi Henrik,

just to make sure I fully understand the steps you followed. In the Spreadsheet, you just added your system account and your SharePoint site URL ? Next you started the flow "BPM Toolkit - ALM - Create BPM Toolkit Structure". This flow is supposed to create your SharePoint lists and update the spreadsheet with the SharePoint lists URL.. Is the Flow "BPM Toolkit - ALM - Create Lists" activated ?

— Reply to this email directly, view it on GitHub https://github.com/sergeluca/Power-Platform-BPM-Toolkit/issues/12#issuecomment-1019513536 , or unsubscribe https://github.com/notifications/unsubscribe-auth/AULEIR5RGQM2YSIM26TFYBDUXQQQNANCNFSM5FYQGCOQ . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub . You are receiving this because you commented.Message ID: @.***>

sergeluca commented 2 years ago

I'm working on it. Many new features are coming, plus easier deployment (environment variables). also, the tool is more mature. I'm currently working on the new deployment process. Small question, which column name did you have to change?

KInd regards

Serge Luca

Business Applications (Power Automate & PowerApps) MVP

Creator of the open-source Power Platform BPM Toolkit

https://github.com/sergeluca/Power-Platform-BPM-Toolkit

Power Platform Associates, Belgium

P: +32 472 885 928

E: @.**@.>

Bloghttp://sergeluca.wordpress.com/ | Linkedin http://www.linkedin.com/in/sergeluca | Twitter http://www.twitter.com/sergeluca | Webhttp://www.shareql.com/

[cid:c1ed6e50-adfc-4eb6-8649-fc816491c77a]

[cid:b6ff497e-fde3-4dc3-a690-6e0e173c90f3]


From: henrikStr @.> Sent: Monday, 14 February 2022 16:52 To: sergeluca/Power-Platform-BPM-Toolkit @.> Cc: serge Luca @.>; Comment @.> Subject: Re: [sergeluca/Power-Platform-BPM-Toolkit] Error while trying to create the lists on sharepoint (#12)

Hi Serge,

I was able to get the BPM Toolkit to work. I had to change the name of the column and to active and fix/activate some of the flows by hand.

I have an additional question about the next release. In the readme file in github you announced the production mode release for this February. I have not found further information about it. Therefore my question: Is the production mode coming this month and will it be able to handle attachments and files?

With kind regards,

Henrik

Von: sergeluca @.> Gesendet: Sonntag, 23. Januar 2022 16:58 An: sergeluca/Power-Platform-BPM-Toolkit @.> Cc: henrikStr @.>; Comment @.> Betreff: Re: [sergeluca/Power-Platform-BPM-Toolkit] Error while trying to create the lists on sharepoint (#12)

Hi Henrik,

just to make sure I fully understand the steps you followed. In the Spreadsheet, you just added your system account and your SharePoint site URL ? Next you started the flow "BPM Toolkit - ALM - Create BPM Toolkit Structure". This flow is supposed to create your SharePoint lists and update the spreadsheet with the SharePoint lists URL.. Is the Flow "BPM Toolkit - ALM - Create Lists" activated ?

— Reply to this email directly, view it on GitHub https://github.com/sergeluca/Power-Platform-BPM-Toolkit/issues/12#issuecomment-1019513536 , or unsubscribe https://github.com/notifications/unsubscribe-auth/AULEIR5RGQM2YSIM26TFYBDUXQQQNANCNFSM5FYQGCOQ . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub . You are receiving this because you commented.Message ID: @.***>

— Reply to this email directly, view it on GitHubhttps://github.com/sergeluca/Power-Platform-BPM-Toolkit/issues/12#issuecomment-1039248886, or unsubscribehttps://github.com/notifications/unsubscribe-auth/ACXEHP47SAID7J36MGIXGQLU3EQMDANCNFSM5FYQGCOQ. Triage notifications on the go with GitHub Mobile for iOShttps://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Androidhttps://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub. You are receiving this because you commented.Message ID: @.***>