111 posts tagged with "SharePoint"

I ran my setup flow a second time to prove it was safe to run again. Instead of finishing in seconds, it sat on Waiting for half an hour, then failed: Action 'Remove_Title_from_the_view' failed: BadGateway. Behind the 502 was SharePoint saying Invalid field name. The first run had already removed that column from the view, and asking again was an error that Power Automate retried for minutes at a time.

My flow failed with Invalid JSON. A token was not recognized in the JSON content. The JSON it sent looked fine in the designer. In the run, a false from my data had become False, with a capital F, which isn't JSON. An if() expression fixed it.

I saved a cloud flow, and the action I had open in Power Automate's new designer suddenly showed No additional information is needed for this step, Not connected. and an empty Code view. It looked as if Save had wiped the action. It hadn't: selecting the action again brought everything back.

This part lets managers keep each job title's plan up to date: add a competency, change its level or remove it, from one Competency screen. Every change applies to everyone with that job title, so the screen says so, checks for duplicates, asks before removing, and tells reviewers when a plan changed under a response.

Adding an item and editing one need almost the same screen. Instead of building two, build one and open it in two ways: with the item's ID to edit it, or with a blank ID to add a new one. Each formula that differs asks one question, IsBlank(locCompetencyId).

A soft delete hides an item instead of deleting it. A Yes/No column, such as IsActive, says whether the item is in use. "Removing" sets it to No, and every list in the app shows only items where it's Yes. The item stays in SharePoint with its history, and it can come back.

To stop people from adding the same item twice, look for it before you save. If a matching item exists, show a message and don't save. On SharePoint, the lookup can run in the list itself, as long as it compares columns with =.

A SharePoint Choice column already knows its options. Choices gives them to your app as a table with one column, Value. Use it as a combo box's Items, and the app lists exactly the options defined in SharePoint, with nothing typed twice.

This part builds the screen where a manager decides: approve a response, or decline it with a comment the employee sees. Then it tests the whole loop with a real employee in her own browser. That test found a bug: the employee didn't see her manager's decision. The fix, a Refresh button on every screen, ends the part.

Refresh gets a fresh copy of a data source, so the app shows changes other people made while it was running. It has no result, and it only works in formulas that run on an action, such as OnSelect and OnVisible. If your screen keeps data in variables, run its queries again after Refresh.